Explore BrainMass
Share

conversion: unnormalized relation, 1NF, 2NF, 3NF

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Nazca Cinemas is a small movie theater that would like you to design a movie scheduling database system for them. The theater has four rooms (screens). Each room has its own unique ID and the seating capacity and screen size for each are recorded. Each movie is assigned a unique movie ID and its title and runtime are recorded.

Assume the following:

A movie can be shown more than once on a given date.
A movie can be shown more than once in a given room.
A movie can be shown in more than one room simultaneously.
Several showings can be booked at different start times in a given room on a given date.

The following unnormalized relation has been developed based on this case. Do not add any additional attributes.

SHOWING (MovieID, Title, Runtime, RoomID, ScreenSize, Capacity, Date, StartTime)

1. Convert the unnormalized relation into 1NF and briefly discuss the changes that were necessary.
2. Convert the 1NF relation to 2NF and briefly discuss the changes that were necessary.
3. Convert the 2NF relation to 3NF and briefly discuss the changes that were necessary.

© BrainMass Inc. brainmass.com October 24, 2018, 6:27 pm ad1c9bdddf
https://brainmass.com/computer-science/databases/conversion-unnormalized-relation-1nf-2nf-3nf-41292

Solution Summary

Conversion with unnormalized relation, 1NF, 2NF, 3NF is emphasized.

$2.19
See Also This Related BrainMass Solution

Database - conversion: unnormalized relation, 1NF, 2NF, 3NF

The following unnormalized relation shows a modified version of the Nazca Cinemas case problem. A ShowingID attribute has been added to the relation. Each individual showing (a given movie in a given room on a given date at a given time) of a movie is given its own unique ShowingID. Using the modified version of the unnormalized relation, rework the normalization process. Do not add any additional attributes to those shown in this unnormalized relation:

SHOWING (ShowingID, MovieID, Title, Runtime, RoomID, ScreenSize, Capacity, Date, StartTime, EndTime)

1. Convert the modified unnormalized relation into 1NF and briefly discuss the changes that were necessary.
2. Convert the 1NF relation to 2NF and briefly discuss the changes that were necessary.
3. Convert the 2NF relation to 3NF and briefly discuss the changes that were necessary.

View Full Posting Details