$"$~ Assignment $18$ ~

This assignment is based on lecture Chapter $05-$ Fourth Normal Form

Create a Word document named YourName$\_18$ and answer the following questions.

Define fourth normal form.

For question $2,$ use the following table shorthand and dependencies about a table that stores data about cars.

Table shorthand:

VroomVroom $($Model$,$ Year, Color$)$

Multi$-$valued Dependencies that exist:

Model $$ Year

Model $$ Color

Convert the above third normal form VroomVroom table into a series of tables that satisfy fourth normal form and provide the new table shorthand.

For questions $3-4,$ use the following table shorthand of a modified Reservation table based on the Colonial database. The Reservation table is in second normal form.

Table shorthand:

Reservation $($ReservationID$,$ TripDate, TripID, TripName,

CustomerNum, CustomerName, Phone$)$

Convert the above second normal form Reservation table to a series of tables that satisfy third normal form and provide the new table shorthand.

After converting to third normal form it should also be in fourth normal form, in a few sentences, justify why.

ICS $129-$ Introduction to Databases XR$11"$