Please draw the E-R Diagram for the following system, being sure to include the attributes and note which attributes are the identifiers. Imagine a sales system that tracks customers, orders, and sales representatives. Customers can place multiple orders, but each order is associated with a single customer. Additionally, every customer is classified as being either a “Major Customer” or a “Minor Customer.” Major Customers are assigned to a single Sales Representative who acts as their primary point of contact, while Minor Customers have no connection to the Sales Representatives. Sales Representatives can be assigned to multiple customers, and whenever one of their customers places an order, the Sales Representative is also associated with the order. Overall, the system tracks the customer IDs, customer contact number(s), order numbers, goods ordered, payment status, sales representative ID, and sales representative name, as well as the customer point-of-contact for major customers.
Please draw the E-R Diagram for the following system, being sure to include the attributes and note which attributes are the identifiers. Imagine a sales system that tracks customers, orders, and sales representatives. Customers can place multiple orders, but each order is associated with a single customer. Additionally, every customer is classified as being either a “Major Customer” or a “Minor Customer.” Major Customers are assigned to a single Sales Representative who acts as their primary point of contact, while Minor Customers have no connection to the Sales Representatives. Sales Representatives can be assigned to multiple customers, and whenever one of their customers places an order, the Sales Representative is also associated with the order. Overall, the system tracks the customer IDs, customer contact number(s), order numbers, goods ordered, payment status, sales representative ID, and sales representative name, as well as the customer point-of-contact for major customers.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
