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 marksETS 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 employees working in different departments in this company. Each employee is assigned to work in only one department and at least employee isare 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. marks
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
