Concepts of Database Management (8th Edition) - Chapter A, Problem 2E

Complete an information-level design for Holt Distributors.

Submit your completed design in DBDL (database design language) format showing all keys (primary, foreign, alternate, and secondary). It is not necessary to show all the normalization steps for each of the user views, although you may find this to be a useful tool to ensure that your tables are in 3NF (third normal form).

(Hint: There are a total of 11 tables in the Final Design)

ORDER ACKNOWLEDGMENT PICKING LIST 10/12/2015 Order 12424 HOLT DISTRIBUTORS 146 NELSON PLACE BRONSTON, MI 49802 SOLD SHIP TO: TO: Smith Rentals 153 Main St Suite 102 Grandville, MI 49494 A& B Supplies 2180 Halton Pl. Arendville, MI 49232 Customer PO. No. Order Date Sales Re 15 10-Brown, Sam Quantity Order Ship BiO Item Number Description Price Amount AT414 BT222 Lounge Chair $42.00 651.00 125200 204.00 Arm Chair ORDER ACKNOWLEDGMENT PICKING LIST 10/12/2015 Order 12424 HOLT DISTRIBUTORS 146 NELSON PLACE BRONSTON, MI 49802 SOLD SHIP TO: TO: Smith Rentals 153 Main St Suite 102 Grandville, MI 49494 A& B Supplies 2180 Halton Pl. Arendville, MI 49232 Customer PO. No. Order Date Sales Re 15 10-Brown, Sam Quantity Order Ship BiO Item Number Description Price Amount AT414 BT222 Lounge Chair $42.00 651.00 125200 204.00 Arm Chair