Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fucntional Dependancy Given the following business rules, draw a functional dependency diagram that reflects these rules. Upload your diagram before the time expires The attributes
Fucntional Dependancy
Given the following business rules, draw a functional dependency diagram that reflects these rules. Upload your diagram before the time expires The attributes you should use are: theater name, theater zipcode, screen number, date, time, movie title, movie length, and number of seats. Show each attribute once and do not normalize. Each theater has a unique name and is located within a particular zipcode. Several theaters can exist in the same zipcode. A theater may have several screens, but a given screen (identified by the combination of a screen number and a theater name) is located at only one theater. At a given time on a given day on a given screen in a given theater, only one movie will be shown at a time. The same movie may show on different screens in the same theater at the same time. Each screen has a fixed number of seats Each movie has a specific length Given the following business rules, draw a functional dependency diagram that reflects these rules. Upload your diagram before the time expires The attributes you should use are: theater name, theater zipcode, screen number, date, time, movie title, movie length, and number of seats. Show each attribute once and do not normalize. Each theater has a unique name and is located within a particular zipcode. Several theaters can exist in the same zipcode. A theater may have several screens, but a given screen (identified by the combination of a screen number and a theater name) is located at only one theater. At a given time on a given day on a given screen in a given theater, only one movie will be shown at a time. The same movie may show on different screens in the same theater at the same time. Each screen has a fixed number of seats Each movie has a specific lengthStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started