Question: 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-make

 Complete an information-level design for Holt Distributors Submit your completed design

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-make an educated guess for the alternate keys and secondary keys) in a Microsoft Word document. 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 tinal design.0 ORDER ACKNOWLEDGMENT/PICKING LIST 10/12/2015 Order 12424 HOLT DISTRIBUTORS 146 NELSON PLACE BRONSTON, MI 49802 SHIP TO: SOLD 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 R 1354 PO335 10/02/2015 10-Brown, Sam uant Order Ship B/O Item Number DescriptionPrice Amount AT414 BT222 Lounge Chair $42.00 Arm Chair 425200 204.00 S51.00 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-make an educated guess for the alternate keys and secondary keys) in a Microsoft Word document. 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 tinal design.0 ORDER ACKNOWLEDGMENT/PICKING LIST 10/12/2015 Order 12424 HOLT DISTRIBUTORS 146 NELSON PLACE BRONSTON, MI 49802 SHIP TO: SOLD 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 R 1354 PO335 10/02/2015 10-Brown, Sam uant Order Ship B/O Item Number DescriptionPrice Amount AT414 BT222 Lounge Chair $42.00 Arm Chair 425200 204.00 S51.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!