50%(2)1 out of 2 people found this document helpful
This preview shows page 1 - 18 out of 35 pages.
Order_ID (PK)Donut_ID (PK)Donut_NameDonut_DescriptionUnit_PriceOrder_DateQuanitySpecial_NotesCustomer_IDFirst_NameLast_NameStreet_AddressAptCityStateZip_CodeHome_PhoneMobile_PhoneOther_Phone1NF database is designed by gathering all the data that is needed to be stored for a particular o
order. All fields are atomic. The Subtotal, Line Total, Sales Tax, and Total fields are not included as t
these are calculated fields. The Order_ID is assigned as the primary key. In addition, the Donut_ID i
with a particular order.
OrdersDonutOrderAssignmentOrder_ID (PK)Donut_ID (PK)Order_ID (FK)Order_DateDonut_NameDonut_ID (FK)Special_NotesDonut_DescriptionQuanityCustomer_IDUnit_PriceFirst_NameLast_NameStreet_AddressAptCityStateZip_CodeHome_PhoneMobile_PhoneOther_PhoneTo resolve the partial dependency of the Donut_ID, the Donut table was created and the
e Donut_ID is assigned as the primary key for the table. The Orders table will consist of the order inf
formation and the customer information. The Order_ID is sufficient as the primary key for the table a
e Order_ID and the Donut_ID as the composite foreign keys.
CustomerDonutOrdersOrderAssignmentCustomer_ID (PK)Donut_ID (PK)Order_ID (PK)Order_ID (FK)First_NameDonut_NameOrder_DateDonut_ID (FK)Last_NameDonut_DescriptionSpecial_NotesQuanityStreet_AddressUnit_PriceCustomer_ID (FK)AptCityStateZip_CodeHome_PhoneMobile_PhoneOther_PhoneIn the 3NF, the transitive dependency of the Customer_ID in the Orders table is resolved by creating the CustoAll partial and transitive dependencies have been removed at this point. All fields are atomic and there are no
omer table. The Customer_ID becomes the primary key of the table and is also retained in the Orders table as ao repeating fields. Finally, each table is assigned a primary key that uniquely identifies all rows in the table.
a foreign key.
OrderDonutModel ID = Donut IDOrder_ID (PK)Donut_ID (PK)Client ID = Custumer IOrder_DateDonut_NameBooking ID = Order IDQuanityDonut_DescriptionItem_TotalUnit_PriceSubtotalTaxTotalOrder AssignmentSpecial_NotesOrder_ID (PK)Customer_IDDonut_ID (PK)First_NameLast_Name