Changes between Version 19 and Version 20 of P5


Ignore:
Timestamp:
04/21/26 11:52:45 (11 days ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • P5

    v19 v20  
    7676=== 1NF Check
    7777Every column in the database holds just one value, so there are no lists or multi-value attributes in the cells. There are no repeating columns, each table has a primary key, and all attributes are atomic, so my relations satisfy 1NF.
     78The candidate key of R is: CK = {chapter_id, genre_id, list_id, notification_id, suggestion_id, comment_id, status, content_type, suggestion_type, roles, permission_level}
     79since it is the only combination whose closure contains all attributes of R, and no proper subset of it can determine all attributes of R.
    7880
    7981=== 2NF Check