Question: ERD ( 2 5 marks ) ETS Corporation operates under the following business rules: ETS Corporation is a company which sells different types of car

ERD (25 marks)ETS Corporation operates under the following business rules: ETS Corporation is a company which sells different types of car accessories from various car models. There are more than 20 employees working in different departments in this company. Each employee is assigned to work in only one department and at least 1 employee is/are working in each department . The database will store department id, department name and department location for each of the departments. Whereas information about employee id, employee name, phone number, address, salary and taxId will be stored for each employee. Each employee may accept more than one order from the customer; however, each order can only be assigned by a particular employee. Other information such as order number, order date, a subtotal, a tax total, a shipping cost, a shipping date, an order total cost, and an order status will also be stored for each order. Normal information such as customer id, customer name, customer address, customer phone number, and customer email will be stored for each customer record. A customer (retail or wholesale) can place many orders.Based on the above information, draw an Entity Relationship Diagram using Crows Foot model. (25 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!