Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a conceptual ER diagram given a set of functional requirements like a this picture please Consider a MAIL_ORDER database in which employees take orders

image text in transcribed

Create a conceptual ER diagram given a set of functional requirements like a this picture please

Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows:

1- The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code.

2- Each customer of the company is identified by a unique customer number, first and last name, and Zip Code

3- Each part sold by the company is identified by a unique part number, a part name, price, and quantity in stock.

4- Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.

Book ISBN Title Author Book Copy Loan Copy # Name Date Due Reservation Patron Name Loan 1 Date Reserved Loan 2 Loan 3 Loan 4 Loan 5 Name Library Card # Book ISBN Title Author Book Copy Loan Copy # Name Date Due Reservation Patron Name Loan 1 Date Reserved Loan 2 Loan 3 Loan 4 Loan 5 Name Library Card #

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 And Expert Systems Applications Dexa 2023 Workshops 34th International Conference Dexa 2023 Penang Malaysia August 28 30 2023 Proceedings

Authors: Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil ,Bernhard Moser ,Atif Mashkoor ,Johannes Sametinger ,Maqbool Khan

1st Edition

303139688X, 978-3031396885

More Books

Students also viewed these Databases questions

Question

Have I incorporated my research into my outline effectively?

Answered: 1 week ago