INFORMATION MANAGEMENT SUBJECT SEATWORK 1 - CREATING ERD

CREATE ERD BASED ON THE GIVEN EXAMPLE

1. Seatwork: You have been assigned the task of designing an Entity-Relationship (ER) diagram for an ordering system. This system facilitates customers in placing orders, with each order containing multiple products supplied by various suppliers. Customers are characterized by unique IDs, names (first name, middle name and last name), and contact information, while orders are distinguished by unique IDs, order dates, and grand total. Order details represent individual items within an order, linking each item to a specific order and product, and containing attributes such as quantity and unit price. Products are uniquely identified by IDs, and are associated with names, descriptions, and prices. These products, in turn, are supplied by suppliers, who are identified by unique IDs and characterized by names and contact information (landline and cellphone). Your task is to design an ER diagram that comprehensively represents these entities, their attributes, and the relationships between them, considering cardinality and participation constraints where applicable.