Purchase Solution

unnormalized relation

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

Solution Summary

Unnormalized relation is examined.

Solution Preview

1.
The original relation is already in 1NF, because each of its column is of atomic value and does not contain composite value. ScreeSize can be described as ...

Purchase this Solution


Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.