125k views
2 votes
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).

User DimyG
by
4.7k points

1 Answer

4 votes

Answer:

Following is given the detailed solution for each part.

I hope it will help you!

Step-by-step explanation:

Task 1 (25 points): In database [your Pitt username], create the following entity-example-1
Task 1 (25 points): In database [your Pitt username], create the following entity-example-2
Task 1 (25 points): In database [your Pitt username], create the following entity-example-3
Task 1 (25 points): In database [your Pitt username], create the following entity-example-4
User Rns
by
5.1k points