1. Engineering
  2. Computer Science
  3. a list of database application projects is available at httpwwwdssbookscomwebprojectsmanualhtml...

Question: a list of database application projects is available at httpwwwdssbookscomwebprojectsmanualhtml...

Question details

A list of database application projects is available at http://www.dssbooks.com/web/ProjectsManual.html Project 48 describes a database application for a movie theater. The movie theater database should include data about the following: -Customers with their ID, name, address, phone number, and e-mail -Employees with their ID, name, date of hire, employment history, and salary, where employment history is a multi-valued attribute -Producers with their ID, name, contact information (address, phone number, and e-mail), and current balance -Movies with their ID, title, year of production, rating, description, awards won, and actors, where awards won and actors are multi-valued attributes -Showrooms with their name, location, and capacity When a show of a movie is assigned to a showroom, the database records the date and time of the show and the total number of tickets available for the show. When a customer purchases ticket(s) for a show of a movie, the database records the ticket number, date, unit price, number of tickets purchased, and amount paid. The number of tickets purchased for a show decreases the total number of tickets available for the show. When a customer signs up as a member to buy tickets online, the member’s login name and password are recorded. When the movie theater purchases movie(s) from a producer, the database records the transaction number, purchase price, purchase date, payment due date, and amount due. 1. Create a query that presents the average room usage per showroom in the current year. 2. Create a query that lists the 100 most preferred customers based on the amounts that the customers spent in the movie theater. 3. Create a query to present information about the producer that the movie theater did the most business during the current year. 4. Create a query that prompts for a date and a movie title and then presents the number of tickets available per show for the movie on that date.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution