Read through several of the online Normalization tutorials. Then look at the data described below. See if you can break this data down into a series of related tables using the normalization rules. We will go over this on Wednesday.   You can put your answer into an ERD  (Entity Relationship Diagram) or a series of tables.  Mark the key fields.  Please have 2 copies of your work.  Turn one in at the start of class, and you can mark on the other as we go through the problem during class.

Problem:

Suppose you were designing a database for Ford dealers in Western Washington. Each Dealer had a name, address, phone, and a group of cars each with a VIN number.  Each car had a color, model and year. Every Dealer had a group of employees with a name, age, position, position base salary, and position bonus. You will have a group of customers, for which you will store the name, phone, car purchased (vin number), make, model, salesperson, purchase price and date for each sale. Each customer may have several kids. Store the children's name and birthday for each customer.  Also, store the name, phone, and address of all the advertising companies working for Ford, as well as the advertising purchase date and amount for each dealership's advertising purchase.

 

[Home] [Syllabus] [Sessions] [Writing Code] [Help] [Setup] [Instructor]