Question

In a multiplex, movies are screened in different auditoriums. One movie can be shown in 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:

Movie(Movie_ID, MovieName, ReleaseDate) Audi(AudiNo, Movie_ID, Seats, ScreenType, TicketPrice)

Is it correct to assign AudiNo as the primary key in the AUDI relation? If no, then suggest an appropriate primary key.

Answer 1

Yes, because every auditorium will be assigned a unique id. No two auditoriums will have the same id.