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.