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: 3 years ago

Preview 1 out of 15 pages

Buy Now

Instant download

We Accept: