Case Study:The aim of this assignment is to produce a database system that is used to record data and informationrelated to a CINEMA.This database should store relevant data as the following, where any invalid entries should be filteredaccordingly

Case Study:
The aim of this assignment is to produce a database system that is used to record data and information
related to a CINEMA.
This database should store relevant data as the following, where any invalid entries should be filtered
accordingly.
1. The cinema has several theatres, all may be showing movies at the same time. There are
theatres for 3D movies as well. The occupancy of 3D theatres are smaller than ordinary
theatres.
2. A movie can be shown in more than one cinema, but at different times. However, the same
movie title can be shown at ordinary theatre and 3D theatre at the same time. Movies are
categorize into genre and classifications.
3. The schedule for each movie is set by the cinema staff, including the venue and prices. Prices
of tickets varies between movie types, customer categories and schedule.
By going through some processing, the database system should be able to produce various types of
statistics. Below are some questions or requests that may be used to consider the display.
? Information on specific movie
? List of all or specific movies shown for the day/week/month.
? Total ticket collection for a specific movie or all movies.
? Ranking of movie ticket sales.
? and many more…
Conduct research on the required case given. Understand the use of the system and how the database
is used as its data store that can support data presentation and queries from the user. Later your team
should replicate the database system and develop your version of it.