Discuss the changes that were necessary

Assignment Help Computer Engineering

Reference no: EM1336073

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.

Reference no: EM1336073

Questions Cloud

Elucidate this point of language so that it understandable : Elucidate this point of language so that it is understandable to someone untrained in economics.

Context of hate-crime : What can be done to change the incidence of hate-crime? Is there one context of hate-crime that would be easier to address than others?

Type of organizational form fosters teamwork : Which type of organizational form fosters teamwork in the best manner?

The impact of real gdp the unemployment rate : Also address the impact of real GDP, the unemployment rate, and the inflation rate as measured by the consumer price index (CPI).

Discuss the changes that were necessary : Nazca Cinemas is a small movie theater that would like you to create a movie scheduling database system for them. The theater has four rooms (screens).

The source of standards : The source of standards that uses the best performance measures

Victimized person : As a criminal justice professional, what do you feel is most important when studying victims of prison violence, school violence, campus violence, and workplace violence?

How many employees will you need to start : How many employees will you need to start and What positions would they be in? Would you offer benefits?

Explain important information about three page marketing : Explain Important information about three Page Marketing Paper and Consider how to promote another innovative Californian firm's new product and in doing so demonstrate your understanding of a promotion strategy

User Account

All Pages