Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

Solution provided by:
Champake Mendis, MEngSc, PhD
Education
  • BSc (Hons), University of Colombo - Sri Lanka
  • MEngSc, University of Melbourne
  • Certificate IV in Training & Assessment , Australian Business Council
Recent Feedback
  • "Thank you!"
  • "Thank you."
  • "Thanks a lot for you help and support"
  • "Sorry about the late payment but the assignment was sufficient and appreciated. Good work"
  • "Great description! Thank you for your quick response."
Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

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.

C# variables and classes

This quiz contains questions about C# classes and variables.

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.

View More Free Quizzes
Related BrainMass Solutions

  • unnormalized relation

    41291 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.

  • Transforming normal forms in database systems

    The 1NF database tables must meet the definition of a relation i.e.

  • Improving Table Designs Using Normalization.

    Let us see the rules for a table to be in 1NF, 2NF and 3 NF. 1NF - A relation R is in first normal form (1NF) if and only if all underlying domains contain atomic values only. 2NF- A relation R is in second normal form (2NF) if and only if it is

  • Custom order entry system

    Let us see the rules for a table to be in 1NF, 2NF and 3 NF. 1NF - A relation R is in first normal form (1NF) if and only if all underlying domains contain atomic values only. 2NF- A relation R is in second normal form (2NF) if and only if it is

  • Normalization within Database

    Codd, "Further Normalization of the Data Base Relational Model"[7] 2NF Second normal form means that it is in 1NF and every non-prime attribute of the relation is dependent on the whole of every candidate key. 3NF Third normal form is to ensure

  • real world example that demonstrates one of the normal forms

    First Normal Form: The first normal form (1NF) requires that, in a given table, the data type of each field must not change from record to record.

  • Normalisation of Database Design

    Explain how you redesign your tables to satisfy the requirements of 1NF, 2NF and 3NF. When necessary, it is perfectly okay to create another table.

  • Database Normalization: 3 NF

    Relation Schema b) is only in 2NF. because according to 3NF all relations should be with primary key but here the relation equipment_type-> software_type is among two NON-KEY attributes so it only in 2NF but not in 3 NF.

  • Process of normalization

    443130 Process of normalization Describe and illustrate the process of normalization for the following relation to Second (2NF), and Third (3NF). R(ABCDEF) Aâ?'B Dâ?'E Bâ?'C Eâ?'F Donâ??

View More Related Solutions