Changes between Version 4 and Version 5 of P5

Timestamp:

04/07/26 22:37:30 (6 days ago)

Author:

211099

Comment:

--

P5

@@ -71 +71 @@
 Every 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.
 
+=== 2NF Check
+Every table that has a simple (non-composite) primary key is already in 2NF, so we only need to check the tables that have composite keys.
+STATUS {story_id, status} → There are no other attributes, so it satisfies 2NF.
+CONTENT_TYPE {notification_id, content_type} → There are no other attributes, so it satisfies 2NF.
+SUGGESTION_TYPE {suggestion_id, suggestion_type} → There are no other attributes, so it satisfies 2NF.
+LIKES {user_id, story_id} → like_created_at depends on {user_id, story_id} together, so it satisfies 2NF.
+COLLABORATION {user_id, story_id} → collab_created_at depends on {user_id, story_id} together, so it satisfies 2NF.
+ROLES {user_id, story_id, roles} → There are no other attributes, so it satisfies 2NF.
+PERMISSION_LEVEL {user_id, story_id, permission_level} → There are no other attributes, so it satisfies 2NF.
+HAS_GENRE {story_id, genre_id} → There are no other attributes, so it satisfies 2NF.
+READING_LIST_ITEMS {list_id, story_id} → added_at depends on {list_id, story_id} together, so it satisfies 2NF.
+NOTIFY {user_id, story_id, notification_id} → There are no other attributes, so it satisfies 2NF.
+NEED_APPROVAL {suggestion_id, story_id, chapter_id} → There are no other attributes, so it satisfies 2NF.
+Since there are no partial dependencies in any of the tables, this schema satisfies 2NF.