Changes between Version 6 and Version 7 of P5

Timestamp:

04/07/26 22:51:55 (6 days ago)

Author:

211099

Comment:

--

P5

@@ -97 +97 @@
 
 Since there are no partial dependencies in any of the tables, this schema satisfies 2NF.
+
+=== 3NF Check
+We checked all FDs where the left side is a primary key, so we can skip those. We only need to check:
+FD6: {story_id, chapter_number} → chapter_id → here we can see that there is a UNIQUE constraint on {story_id, chapter_number}, which tells us that it is also a superkey. 
+After this we can safely say that the schema satisfies 3NF.