Question: Please re check the answer given and confirm with an expert. A database of movies currently showing in the city has a table of the
Please re check the answer given and confirm with an expert. A database of movies currently showing in the city has a table of the form playing Title Theatre, Location where Title is the name of the movie, Theatre is the name of the cinema theatre and Location is the place where the theatre is located a mall or multiplex
We assume that no pair of movies currently running have the same title and no two cinema theatres have the same name. A cinema theatre may be showing different movies in different time slots, but no location has two cinema theatres showing the same movie.
X What functional dependencies can you infer from these constraints?
B Compute a BCNF decomposition of the table Playing.
C Explain whether your BCNF decomposition is dependency preserving.
D Test if your decomposition using test for lossless join property algorithm.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
