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, and 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. Prepare a 5-minute presentation that includes an explanation of primary keys and foreign keys.
Answer to relevant QuestionsDevon Degosta set up an Access database to manage her web design business. She has asked you to create a report that summarizes and identifies projects that are assigned to more than one employee. Recreate the Access ...Enter the records in the following table. Note that you do not enter the Product ID; it is an auto numbering field that generates the next value. Save your work.What is customer relationship management (CRM)? What are the objectives of CRM? How do organizations measure their customer relationship? How do information systems support each objective of CRM? What are three basic ...Visit each site (Careerbuilder.com and Monster.com) and check out the “About Us” sections to better understand how the two companies differ. Compare and contrast their vision statements.What is the difference between usability and accessibility? How do Web site developers test for usability? How can Web site design improve accessibility? How do text and background color combinations relate to Web site ...
Post your question