Consider a MAIL_ORDER database in which employee take orders for parts from cust

Question

Consider a MAIL_ORDER database in which employee take orders for parts from customers. The data requirements are summarized as follows:
a. The mail order company has employees, each identified by a unique employee number, first and last name, and ZIP code.
b. Each customer of the company is identified by a unique customer number, first and last name, and ZIP code.
c. Each part sold by the company is identified by a unique part number, a part name, price and quantity in stock.
d. 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.



required to prepare a report containing the followings:
1. ER-diagram: Design an Entity-Relationship diagram.
2. Relational schema: Construct appropriate table (relational schema) for the ER diagram above.
3. Data table or data dictionary: Design data tables for the above situation.
4. SQL statements for creating tables.

Explanation / Answer

Answer question

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.