Question: 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

Fucntional Dependancy Given the following business rules, draw a functional dependency diagram

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 length

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!