ER Exercise: Car dealership

Below is an ER model for a car dealership.

er-in-class2.png

Questions you need to be able to answer:

  1. List the entity types.
  2. Does a car have to be classified as either new or used?
  3. For a used car, can you tell what model it is?
  4. What's the minimum number of cars that have to be classified as a certain type of model?
  5. Does a salesperson ever have to be involved in a test drive?
  6. If there's a test drive, does a salesperson have to be involved in it?
  7. What's the minimum number of cars a customer can purchase?
  8. Can we say exactly how many customers a certain salesperson sells a certain car to?
  9. What's the minimum number of customers a sales person has talked to?
  10. How many tables would be needed for this database?
  11. How many primary keys would be needed for this database?
  12. List all the tables in which a foreign key to Customer appears.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License