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.

Given the above requirements for the movie theater database, use an E-R diagram to describe the Customer, the Employee, the Producer, the Movie, and the Showroom entities, along with their attributes, maximum/minimum cardinalities, and superclass/subclass entities.

I need help wit the cardinalities and the super/sub classes entities as well