In a multiplex, movies are screened in different auditoriums. One movi

1.	In a multiplex, movies are screened in different auditoriums. One movie can be shownin more than one auditorium. In order to maintain the record of movies, the multiplex maintains a relational database consisting of two relations viz. MOVIE and AUDI respectively as shown below: [4]Movie(Movie_ID, MovieName, ReleaseDate) Audi(AudiNo, Movie_ID, Seats, ScreenType, TicketPrice)a) Is it correct to assign Movie_ID as the primary key in the MOVIE relation? If no, then suggest an appropriate primary key. b) Is it correct to assign AudiNo as the primary key in the AUDI relation? If no, then suggest appropriate primary key
Answer» ANSWER: ygggugughhgghghgjvjjhihihkhkhiijk

In a multiplex, movies are screened in different auditoriums. One movie can be shownin more than one auditorium. In order to maintain the record of movies, the multiplex maintains a relational database consisting of two relations viz. MOVIE and AUDI respectively as shown below: [4]Movie(Movie_ID, MovieName, ReleaseDate) Audi(AudiNo, Movie_ID, Seats, ScreenType, TicketPrice)a) Is it correct to assign Movie_ID as the primary key in the MOVIE relation? If no, then suggest an appropriate primary key. b) Is it correct to assign AudiNo as the primary key in the AUDI relation? If no, then suggest appropriate primary key

Answer»

ygggugughhgghghgjvjjhihihkhkhiijk