ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 3 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 06 Jun 2017 My Price 8.00

Nazca Cinemas case problem

4.      Use the following information to answer question 17 through 19.

 

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)

 

17. Convert the modified unnormalized relation into 1NF and briefly discuss the changes that were necessary.

18. Convert the 1NF relation to 2NF and briefly discuss the changes that were necessary.

19. Convert the 2NF relation to 3NF and briefly discuss the changes that were necessary.

 

Final Exam 1Running head: Final ExamFinal ExamChristopher JonesAllied American UniversityAuthor NoteThis paper was prepared for ISY 325, Final Exam taught by Professor Steve Corbin.

Answers

ComputerScienceExpert
(11)
Status NEW Posted 06 Jun 2017 01:06 AM My Price 8.00

-----------

Not Rated(0)