Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

More Books

Students also viewed these Databases questions

Question

LO3 Define the difference between job satisfaction and engagement.

Answered: 1 week ago