Answered You can hire a professional tutor to get the answer.

QUESTION

TAMUC Inc. wants a database to track used car inventory. A used car can be identified by make, model, year of manufacturing, and price.

 TAMUC Inc. wants a database to track used car inventory. 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. 

Need ERD diagram for the above

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question