WGU C170 Nora's Bagel Bin Database Blueprints. 100% VERIFIED
Second Normal Form (2NF) Bagel ID • Separate the data that depend on just one of the two parts of the primary key into separate tables. • Keep any columns in the original table (now named "Bagel Order Line Item") that still depend on both parts of the original primary key. • Fill in each shaded cell within the tables with an attribute from the 1NF blueprint in the previous section. • Fill in the dotted cells between the tables with the cardinality of the relationship between those two tables: one- to-one (1:1), one-to-many (1:M), many-to-one (M:1), or many-to-many (M:M).
Written for
- Institution
-
Western Governers University
- Course
-
WGU C170
Document information
- Uploaded on
- April 1, 2024
- Number of pages
- 3
- Written in
- 2023/2024
- Type
- Other
- Person
- Unknown
Subjects
-
second normal form 2nf bagel id