Reference no: EM132251033

Draw ERD for each of the following situation:

1. A used car can be identified by make, model, year of manufacturing, and price. Often customers can purchase at least one used car from the dealer, but they could buy as many as they want. A used car, however, can be owned by only one customer. For each customer, name, address, and phone number are recorded. When a customer buys a used car, monthly payment and total balance of that transaction are stored in the database. For each used car, there will be only one salesperson actively sell the car. Salesperson is identified by name, phone number, and email address. For each car sale, salesperson will receive 30% commission rate based on the value of the car sale.

2. Doctor is identified by name, address, specialty, and experience. Nurse is identified by name, address, and number of working years. Patient(s) often receive multiple treatments from multiple doctors. When patient receive treatment from doctor, a patient record will be recorded. Patient is identified by patient id, name, and phone number. A patient record is identified by bill and diagnose. For each patient record, only one nurse is assigned to take care the record. However, multiple nurse(s) can work under one doctor