Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

6. Write an equation for the addition of HCN to propanal

Answered: 1 week ago

Question

=+ how might this lead to faster growth in productivity?

Answered: 1 week ago