Reference no: EM13950336
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.
|
Axial-flow compressor operating at steady state
: Air is compressed in an axial-flow compressor operating at steady state from 27°C, 1 bar to a pressure of 2.1 bar. The work required is 94.6 kJ per kg of air flowing. Heat transfer from the compressor occurs at an average surface temperature of 40..
|
|
Describe the var approach to market risk
: Describe the VAR approach to market risk. Is VAR related to the normal distribution? Can VAR handle extreme events (black swans)? Explain how VAR is applied to portfolios.
|
|
El bulli: the taste of innovation
: Instructions: Read the case which can be found on the iTunes U course shell and write a brief case analysis about the organization. A case analysis is NOT a summary, but rather an in depth examination of the concepts described as they relate to th..
|
|
What is the duration of a zero coupon bond
: What is the duration of a zero coupon bond? What is the relationship between (a): duration and maturity? (b): between duration and yield? (c): between duration and coupon interest? What is the economic meaning of duration? How is duration related to ..
|
|
Convert the 2nf relation to 3nf and briefly discuss changes
: Several showings can be booked at different start times in a given room on a given date.
|
|
Percentage from your payments goes to is principle payment
: Suppose you borrowed $12,000 at a rate of 9.0% and must repay it in 4 equal installments at the end of each of the next 4 years. How large would your payments be? For year 3, what percentage from your payments goes to is the principle payment?
|
|
Use each type of microscope
: If you were looking for bacteria, Blepharisma, and Volvox in a sample of pond water, which type of microscope would you use to get a good image of each? Explain why you would use each type of microscope. (light microscope or electron microscope)
|
|
Call options intrinsic values and time premiums
: What are the following call options' intrinsic values and time premiums if the price of the underlying stock is $55? Option strike price, Price of the call, Call at $50 $7.00 Call at $55 3.00 Call at $60 0.50
|
|
Calculate the depreciation expense
: You are given the following information for Calvani Pizza Co.: sales = $38,000; costs = $21,000; addition to retained earnings = $5,000; dividends paid = $1,500; interest expense = $5,000; tax rate = 35 percent. Calculate the depreciation expense.
|