Health Care > ANSWERS AND COMMENTARIES > C170 Database Applications TASK 1 2022 BEST GUIDE (All)
C170 Database Applications TASK 1 2022 BEST GUIDE
Document Content and Description Below
A. Construct a normalized physical database model A-1 Complete the 2NF To obtain the second normal form (2NF) for the original table, it was necessary to create three tables: Bagel Order, Bagel Or... der Line Item, and Bagel. This was required so the non-key attributes would functionally depend on the primary key. Bagel Order ID is the primary key for the Bagel Order table, as is Bagel ID in the Bagel table. The third table, Bagel Order Line Item, takes both primary keys in the tables as foreign keys. This table is also the associative table, also known as the intersection table, of Bagel Order and Bagel. The relationship of Bagel Order and Bagel Order Line item from left to right is many-to-one. While being read from right to left, the association is one-to-many. This is because many order line items can be placed in one Bagel Order, and a Bagel Order must contain, at least but not limited to, one item for it to be an order. The cardinality when read is a many-to-one because of the relationship the two tables have. [Show More]
Last updated: 2 years ago
Preview 1 out of 15 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$10.50
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Sep 27, 2022
Number of pages
15
Written in
Additional information
This document has been written for:
Uploaded
Sep 27, 2022
Downloads
0
Views
89
.png)
