Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Draw an ERD containing the Orde r and Customer entity types connected by a 1-M relationship from Customer to Order . Choose an appropriate

1. Draw an ERD containing the Order and Customer entity types connected by a 1-M relationship from Customer to Order. Choose an appropriate relationship name using your common knowledge of interactions between customers and orders. Define minimum cardinalities so that an order is optional for a customer and a customer is mandatory for an order. For the Customer entity type, add attributes CustNo (primary key), CustFirstName, CustLastName, CustStreet, CustCity, CustState, CustZip, and CustBal (balance). For the Order entity type, add attributes for the OrdNo (primary key), OrdDate, OrdName, OrdStreet, OrdCity, OrdState, and OrdZip.

2. Extend the ERD from problem 1 with the Employee entity type and a 1-M relationship from Employee to Order. Choose an appropriate relationship name using your common knowledge of interactions between employees and orders. De fine minimum cardinalities so that an employee is optional to an order and an order is optional to an employee. For the Employee entity type, add attributes EmpNo (primary key), EmpFirstName, EmpLastName, EmpPhone, EmpEmail, EmpCommRate (commission rate), and EmpDeptName.

3. Extend the ERD from problem 2 with a self-referencing 1-M relationship involving the Employee entity type. Choose an appropriate relationship name using your common knowledge of organizational relationships among employees. Define minimum cardinalities so that the relationship is optional in both directions.

4. Extend the ERD from problem 3 with the Product entity type and an M-N relationship between Product and Order. Choose an appropriate relationship name using your common knowledge of connections between products and orders. Define minimum cardinalities so that an order is optional to a product, and a product is mandatory to an order. For the Product entity type, add attributes ProdNo (primary key), ProdName, ProdQOH, ProdPrice, and ProdNextShipDate. For the M-N relationship, add an attribute for the order quantity.

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

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

More Books

Students also viewed these Databases questions

Question

Explain the importance of Human Resource Management

Answered: 1 week ago

Question

4. Show the trainees how to do it again.

Answered: 1 week ago

Question

8. Praise the trainees for their success in learning the task.

Answered: 1 week ago