Your tasks:$$

CREATE the tables using MySQL$.$ You will have to decide the datatypes for each column.

Important: Consider the order in which you create the tables $[20$ points$]$

Write statements that will INSERT at least $5$ rows of data into each table. Some tables will have more based on the relationships $[10$ points$]$

Write statements for each of the following: $[5$ points each: $30$ points in all$]$

DELETE a row from the MovieStream table$$ALTER the Movies table structure by adding a column ACADEMY$\_$AWARD.$$This will show whether the movie won the award for Best Picture

The values for this will hold one of two values $(0$ or $1),$ in other words a Boolean value. $$This column allows Null values.

UPDATE the genre of a movie in the Movies table. Use a movie name present in the table in your update statement. You are updating one movieUPDATE the rating in the MovieStream table for a given movie and streaming service. Use a movie name, streaming service name$$and use the appropriate join clausesSELECT all movies where a given actor has had a role. Use an actor's name and the appropriate join clauses.SELECT the streaming service name and subscription fee and display it in descending order of the service name