Conversion with unnormalized relation

Assignment Help Data Structure & Algorithms

Reference no: EM1380338

Nazca Cinemas is a tiny movie theater that would like you to create a movie scheduling database system for them. The theater has 4-screens. Each screens 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.

Reference no: EM1380338

Questions Cloud

New keynesian model with technology shocks : Discuss the real output and in ation expressions verbally - New Keynesian model with technology shocks

Explain how do we balance this with our new found : We have touched on delicate balance of successful marketing also perhaps social ethics. Explain how do we balance this with our new found POWERFUL knowledge of consumer behaviour.

New keynesian model with technology shocks : Discuss the real output and in ation expressions verbally - New Keynesian model with technology shocks

What specific legal problems do you think rosen might run : Illustrate what specific legal problems do you think Rosen might run into because of his firm's screening methods? Explain how would you suggest he eliminates these problems.

Conversion with unnormalized relation : Nazca Cinemas is a tiny movie theater that would like you to create a movie scheduling database system for them. The theater has 4-screens. Each screens has its own unique ID

Illustrate what are barriers to achieving se characteristics : Illustrate what are barriers to achieving se characteristics. Explain how would I know if organization was making progress towards becoming a learning organization.

Explain how does an understanding of management : Explain how does an understanding of management also organizational behaviour lead to organizational effectiveness also efficiency. Explain why is study of historical management theories important today.

Explain why you would make it considering : Identify decision you would make also explain why you would make it considering: Global versus national values, stakeholder rights also values, national also global laws, economic also shareholder rights also values also social responsibility ma..

Illustrate what are advantages also disadvantages of model : Illustrate what are advantages also disadvantages of each model as it pertains to coordination. Networking.

User Account

All Pages