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 members 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.