Track movies, genres

The Drexel Theatre is a small, family-owned cinema that screens independent and classic films. The lobby is decorated with vintage movie memorabilia including an original poster of Arnold Schwarzenegger, the Terminator, and his famous quote, “I’ll be back.” The theatre has a collection of 5,000 movies on DVD. It hires part-time workers for ticket and concession sales as well as janitorial and projection services. It shows one of its movies every evening at 7:00 p.m. The owner of the Drexel plans to implement a relational database to handle operations. He has asked you to develop the data model for managing the film inventory. He wants to track movies, genres (categories), actors, and languages. He wants a description of each entity’s attributes, and he wants an explanation of how to use primary keys and foreign keys to link the entities together. Work in a small group with classmates to plan the data model. Make a 5-minute presentation that includes an explanation of primary keys and foreign keys.