One of the missing areas in the arts scene in Egypt is a movie database like IMDB, that records the Egyptian movies, cast and reviews over the past years. Such database will allow for movie critics, fans, and researchers to have a structured way of reporting and querying for the scene in Egypt.

One of the sites that provide such information is elcinema.com, which mainly tracks the Egyptian box office, and the movie theatres where different movies were showing for the past 10 years. However, the website allows for viewing the information on a single movie or a single cast member, which make it really cumbersome to draw any analytics or gross reporting, or estimate the size of the movie business in Egypt. In this project, you will be building a database system backend and an application that provide the the analytics and features discussed above.

The database system you design should be based on the Egyptian movies only that are listed on elcinema website (https://elcinema.com/)

Your database design should store information about each Egyptian movie that hit the theatres from 2011 - 2021, including the movie name, description / storyline, duration, release date, genre, total revenue, rating (PG, 16+, 18+, etc.), and cast.

The system should also store basic information about cast members, including their role (Director, Writer or Actor) in specific movies, name, nationality, date of birth, and biography. The system should also be able to store movie reviews and user ratings, where users can use the system to store their review and rating of the movie. Users register on the system through their email addresses, and pick a username, gender, age, and birthdate. After registering, the users can review any movie providing their review in text and their rating (1-10) for the movie.

Description: In this milestone, you are required to design the database ERD, create your database and schema in MySQL server for the data requirements presented on the previous slides.

Deliverables:

• Entity-Relationship Diagram of the Egyptian IMDB System

• Relational Model for your system

• A transcript for the SQL statements used to create your database and schema