Convert the ER model to a Relational model. Prepare SQL DDL commands (create table) to create real database tables for each relation you create (commands will be prepared as text only, no need to run on MySQL at this stage)

 

Relational Schema CAR(car_id, model, color, year, emp_id) CAR_CUSTOMER(customer_id. car id) CUSTOMER(customer_id, customer_name, phone_number) INVOICE(invoice_id, date, customer_id) EMPLOYEE (emp id, emp_name, station_id) WORKSTATION(station_id, floor) Underlined are primary keys and italicized are foreign keys. Explanation Rules for mapping ER to Relational Schema --- Map all entities to relations ---- All underlined attributes are primary keys of relations ---- M:N type relationships are mapped to new relations with primary keys of both entities.