Primary keys and foreign keys

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.

Don't use plagiarized sources. Get Your Custom Essay on
Primary keys and foreign keys
Just from $13/Page
Order Essay
Place Order
Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)