Draw the ERD with appropriate mapping cardinalities for mail order database in which employees, each identified by unique employee number, first name last name and ZIP code. Employee are categorized as manager, clerk ad delivery staff. Each customer of the company is identified by a unique employee number, first and last name and ZIP code. Each part sold by the company is identified by unique part number, part name, price and quantity stock. Each order placed by a customer is taken by a clerk 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. The delivery boy places the order of specified customers. There is a provision of replacing one or many fault parts to the customer but before that it must be verified by the manager.
Draw the ERD with appropriate mapping cardinalities for mail order
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Please hand draw the ER diagram with all attributes and entities not this chatgot generated one.
by Bartleby Expert
