VHT2 TASK 1 Course: Data Management – Applications – C170

VHT2 TASK 1 Course: Data Management – Applications – C170 Rebekah Midkiff WGU ID # 1st NF 1.a - 1.c 2nd NF Bagel order can contain more than one bagel. The bagel order id inside bagel order line item belongs to one bagel order id. One bagel_id in bagel_order_line item can only have one bagel_id. But the bagel item can be on more than one order. The relation would be M:1 Attributes are assigned in this table by looking at partial dependency in the 1NF The bagel_name, bagel_description and bagel_price all depend on the bagel_id Order_date, First_Name, Last_Name, Adress1, Address2, City, State, Zip, Mobile_Phone, Delivery_Fee and Special_ Notes all depend on the Bagel_order_id. Each are dependent on Bagel_order_id Bagel order can have more than one bagel_id and bagel_order_id. But the bagel order line item can only belong to one order id. This relation would be 1:M Bagel_id in the bagel_order_lineitem can only contain one bagel id, but this bagel id can be ordered on many orders. This relation would be M:1. 2.a - 2.c 3rd NF Bagel order will have at the least one bagel. But each bagel has multiple bagel orders therefore multiple bagel order line items. Each bagel order will have at the most one customer. Each customer though can have multiple bagel orders. I moved repeated data to the new table titled customer. It has a Primary Key of customer ID. In the Bagel Order Table customer_id is the foreign key 3.a - 3.c Final Physical Database Model