Application MySQL

A movie data center

What to do

$1.$ Database $-$ You need to create a movie database called "moviecenter" with three tables as below $($AID is actor's ID and MID is movie's ID$)$ :

a$.$ actor $($AID$,$ name$)$

b$.$movie $($MID$,$ title, year, rating$)$

c$.$actor$\_$role $($MID$,$ AID, rolename$).$

Use appropriate data types for each of the attributes, and add appropriate primary$/$foreign key constraints;

Come up your own movie data and populate the tables above by running insert statements in mysql $($XAMPP$)$;

At least $5$ actors in actor table and $3$ movies in movie table;

Each actor should have at least $1$ role in one of the movies;

Each movie should have at least $1$ actor.