Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started