The New-Car Order

You are designing a computer system for a car dealer. The dealer takes orders for cars from a customer. Your job is to design the data for an order.

Here is the information in an order:

1. An order includes the customer.
2. An order includes the information for the car being ordered.
3. An order includes the price.
4. An order includes the date of the order.
5. An order includes a description of the car being ordered.
6. A customer has a last name, a first name, and an address.
7. An address has many fields, which we won't talk about here.
8. A car has a Vehicle Identification Number, which is a String.
9. A car has a Model, which is a String.
10. A car has an interior color.
11. A car has an exterior color.
12. A car may or may not have a sunroof.
13. A car may have one of the following: a Plain Radio, a Fancy Stereo, or a Navigation System.
14. A Fancy Stereo comes with a some number of speakers. The number of speakers is always even and may be between 2 and 12.
15. There are two kinds of Navigation Systems: one that uses Google Maps, and one that uses Apple Maps.

Design the data for this system. Write down the data definitions you need for this system. Your data must interact with some large existing system, so make as few assumptions about the data representation as possible. Write down a list of the data definitions that you expect the existing system to supply.

---

Last modified: Tue Sep 12 15:07:07 Eastern Daylight Time 2017