Third Normal Form Example Data

TransID RentDate CustomerID

1 4/18/95 3

2 4/30/95 7

3 4/18/95 8

4 4/18/95 3

CustomerID Phone LastName FirstName Address City State ZipCode

1 502-666-7777 Johnson Martha 125 Main Street Alvaton KY 42122

2 502-888-6464 Smith Jack 873 Elm Street Bowling Green KY 42101

3 502-777-7575 Washington Elroy 95 Easy Street Smith's Grove KY 42171

4 502-333-9494 Adams Samuel 746 Brown Drive Alvaton KY 42122

5 502-474-4746 Rabitz Victor 645 White Avenue Bowling Green KY 42102

6 615-373-4746 Steinmetz Susan 15 Speedway Drive Portland TN 37148

7 615-888-4474 Lasater Les 67 S. Ray Drive Portland TN 37148

8 615-452-1162 Jones Charlie 867 Lakeside Drive Castalian Springs TN 37031

9 502-222-4351 Chavez Juan 673 Industry Blvd. Caneyville KY 42721

10 502-444-2512 Rojo Maria 88 Main Street Cave City KY 42127

Rentals(TransID, RentDate, CustomerID )

Customers(CustomerID, Phone, Name, Address, City, State, ZipCode )

(Unchanged)

VideosRented(TransID, VideoID, Copy#)

Videos(VideoID, Title, Rent)