Create an ERD and write SQL code to create tables in a database of a DBMS.
Software:
MySQL Workbench + MySQL Server
or
SQL Server Express
Activity:
Create an ERD and relationships with the following entities:
Movies, Directors, Genre (key can be set to unique), Actors, MovieDirectors, MovieActors.
Write the SQL code that will build all the tables.
Populate code with data using insert. Insert at least 10 records per table.
Run the code inside your selected DBMS.
Run select queries
Lab #3 Submission:
SUBMIT photos as "Lab3 - .zip" of the following:
1. ERD with relationship
2. Stored procedure to create the tables
3. Stored Procedure to insert data into each table (insert at least 10 rows of data per table).
4. The database on your DBMS.
5. Select * query from actor, movie, and director; in your DBMS.