[Solved]Lab 2 Design Lab Purpose Create Sample Er Diagram Database Design Deliverables Microsoft V Q37125070
Lab 2: Design Lab
Purpose:
Create a sample ER diagram for database design.
Deliverables:
A Microsoft Visioor Word drawing ofthe design: draw tables with table title, primary key(s), foreignkey(s) and relationships (using connections) specified properly;you are also supposed to bold or indicate the requiredcolumns/fields for each table. If you need to, a brief explanationof your design.[1]
Steps:
- Follow the steps described in class. Create a DB design for thebusiness problem described below[2]. Explain your design choices.1
Create a sample DB design for a small bakery. The bakery isinterested in keeping track of its customers, suppliers, products,ingredients and sales. Bakery sells their products to thecustomers. Bakery uses the ingredients to create their products.Suppliers provide the ingredients to the bakery.
[1] This is optional – at most, a paragraph or two – very short,only listing the NON-obvious choices.
[2] Think about what data makes sense for the business problemand select the fields that make the most sense. Expected designscope is somewhere around 7-10 tables, 2-6 or so fields/table onaverage – your design does not need 100 of fields, but it does needto be able to function on its own.
Expert Answer
Answer to Lab 2: Design Lab Purpose: Create a sample ER diagram for database design. Deliverables: A Microsoft Visioor Word drawin… . . .
OR
