Question

Task 1 (25 points): In database [your Pitt username], create the following entity tables: movies actors locations Each tables logical structure should correspond to the descriptions provided in this assignment. Use CREATE TABLE statement. Task 2 (20 points): In your database, create the following junction tables: movies_actors movies_locations Use CREATE TABLE statement to create junction tables. Task 3 (20 points): For each entity table, insert at least 3 rows using INSERT statement: At least 3 movies in the movies table At least 3 actors in the actors table At least 3 locations in the locations table You can make up your own data for the INSERT statements. Task 4 (10 points): For each junction table, create at least 2 relationships (insert at least two rows of appropriate IDs).

Answer 1

Answer:

Following is given the detailed solution for each part.

I hope it will help you!

Explanation: