Changes between Version 16 and Version 17 of P5
- Timestamp:
- 04/21/26 00:26:31 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
P5
v16 v17 81 81 82 82 chapter_id → chapter_number, chapter_name, title, chapter_content, word_count, rating, published_at, view_count, story_id, chapter_created_at, chapter_updated_at — partial dependency, violates 2NF 83 83 84 genre_id → genre_name — partial dependency, violates 2NF 85 84 86 list_id → list_name, list_content, is_public, user_id, list_created_at, list_updated_at — partial dependency, violates 2NF 87 85 88 notification_id → notification_content, is_read, type, link, notification_created_at — partial dependency, violates 2NF 89 86 90 suggestion_id → original_text, suggested_text, accepted, suggestion_created_at, applied_at, story_id — partial dependency, violates 2NF 91 87 92 comment_id → comment_content, user_id, story_id, comment_created_at, comment_updated_at — partial dependency, violates 2NF 88 93 89 94 R is in 1NF but NOT in 2NF. We decompose R by extracting each group of partially dependent attributes into its own relation, keeping the determinant as the primary key. The story and user attributes are resolved transitively through the decomposition of chapter_id → story_id and story_id → user_id. 95 90 96 === 2NF Decomposition 91 97 After decomposition we verify that every resulting relation satisfies 2NF:
