Changes between Version 5 and Version 6 of P5

Timestamp:

04/07/26 22:39:11 (6 days ago)

Author:

211099

Comment:

--

P5

@@ -73 +73 @@
 === 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.