Question

Given a relational database that consists of the following relations:

Performer (pid: integer, pname: string, years_of_experience: integer, age: integer)

Movie (mname: string, genre: string, minutes: integer, release_year: integer, did: integer)

Acted (pid: integer, mname: string)

Director (did: integer, dname: string, earnings: real)

Do the following using your Azure SQL database:

a) Use SQL statements to create the relations.

b) Populate the relations using SQL statements with the given data posted on Canvas.

Answer 1

a)

CREATE TABLE Performer (

pid int,

pname varchar(100),

years_of_experience int,

age int

);

CREATE TABLE Movie (

mname varchar(100),

genre varchar(20),

minutes int,

release_year int,

did int

);

CREATE TABLE Actor (

pid int,

mname varchar(100)

);

CREATE TABLE Director (

did int,

dname varchar(100),

earnings real

);

2)

NOTE that in order to populate the table, you would need to provide the sample data. Since you have not provided it, I am skipping this part for time being.