PLEASE SEE INSTRUCTIONS BELOW – Goal: The goal of this project is to provide a r

PLEASE SEE INSTRUCTIONS BELOW –
Goal:
The goal of this project is to provide a realistic experience in the conceptual design, logical design, implementation, operation, and maintenance of a relational database and associated applications
Application
A movie data center
What to do
Database – You need to create a movie database with three tables as below:
actors (AID, name)
movies (MID, title, year, rate)
actor_role (MID, AID, rolename).
Use appropriate data types for each of the attributes, and add appropriate primary/foreign key constraints;
Insert data to the above tables (at least 5 actors and 3 movies);
Each actor should have at least 1 role in a movie;
Each movie should have at least 2 actors.
2. Web application – Write PHP programs to produce a web page for user to search movie information.
Required: Search the year and rate of a movie by the movie title.
(Optional) Manager: add, delete, or update movie data.
(Optional) User: search movies by an actor’s name.
What to turn in
Movie Database Report (8 points)
Due in Movie Database Report Dropbox on 11/20/2021 at 8 pm
Table definition and Data population
(All table creation statements and insert statements in a text file)
Project Demo (12 points)
Due in Project Demo Dropbox on 12/04/2021 at 8 pm
Add a new movie to movies table by running a sql statement in mysql (XAMPP)
Search the year and rate of the movie by the title of the new movie just added
Project Report (5 points)
Due in Project Report Dropbox on 12/11/2021 at 8 pm
Description of your project, table definitions, Data population statements, PHP files, screenshots of all interfaces in a word file.