Create a database. You may name it Broadcast.

Use the following DDL queries to create tables on your new database. Create one at a time, ensuring it is successfully added to the database. Hint, if you have trouble making a new H

$2$

$$database$,$ you may add these tables to an existing database instance.

Broadcast ER Diagram

Creating tables

CREATE TABLE SHOW

$($

SHOW

$\_$

ID INT PRIMARY KEY,

SHOW

$\_$

NAME VARCHAR

$(20)$

$$NOT NULL,

SHOW

$\_$

GENRE VARCHAR

$(20))$

;

CREATE TABLE ANCHOR

$($

ANCHOR

$\_$

ID INT PRIMARY KEY,

FIRST

$\_$

NAME VARCHAR

$(20)$

$$NOT NULL,

LAST

$\_$

NAME VARCHAR

$(20)$

$$NOT NULL,

EMAIL

$\_$

ADDRESS VARCHAR

$(100)$

$,$

PHONE

$\_$

NUMBER VARCHAR

$(12))$

;

CREATE TABLE STUDIO

$($

STUDIO

$\_$

ID INT PRIMARY KEY,

STUDIO

$\_$

CITY VARCHAR

$(20)$

$,$

STUDIO

$\_$

NAME VARCHAR

$(20))$

;

CREATE TABLE BROADCAST

$($

BROADCAST

$\_$

ID INT PRIMARY KEY,

BROADCAST

$\_$

TITLE VARCHAR

$(255)$

$,$

BROADCAST

$\_$

DATE DATE NOT NULL,

START

$\_$

TIME TIMESTAMP NOT NULL,

END

$\_$

TIME TIMESTAMP NOT NULL,

STUDIO

$\_$

ID INT NOT NULL,

SHOW

$\_$

ID INT NOT NULL,

CONSTRAINT BR

$\_$

SH

$\_$

FK FOREIGN KEY

$($

SHOW

$\_$

ID

$)$

$$REFERENCES SHOW

$($

SHOW

$\_$

ID

$)$

$,$

CONSTRAINT BR

$\_$

ST

$\_$

FK FOREIGN KEY

$($

STUDIO

$\_$

ID

$)$

$$REFERENCES STUDIO

$($

STUDIO

$\_$

ID

$))$

;

CREATE TABLE ANCHOR

$\_$

ASSIGNMENTS

$($

ANCHOR

$\_$

ID INT NOT NULL,

BROADCAST

$\_$

ID INT NOT NULL,

CONSTRAINT AA

$\_$

PK PRIMARY KEY

$($

ANCHOR

$\_$

ID

$,$

$$BROADCAST

$\_$

ID

$)$

$,$

CONSTRAINT AA

$\_$

A

$\_$

FK FOREIGN KEY

$($

ANCHOR

$\_$

ID

$)$

$$REFERENCES ANCHOR

$($

ANCHOR

$\_$

ID

$)$

$,$

CONSTRAINT AA

$\_$

BC

$\_$

FK FOREIGN KEY

$($

BROADCAST

$\_$

ID

$)$

$$REFERENCES BROADCAST

$($

BROADCAST

$\_$

ID

$))$

;

Populating tables

Populate the ANCHOR table as follows:

ANCHOR

$\_$

ID:

$13$

FIRST

$\_$

NAME: KURT

LAST

$\_$

NAME: WARNER

EMAIL

$\_$

ADDRESS: kurt.warner@nfl

$.$

com

PHONE

$\_$

NUMBER:

$890$

$-$

$013$

$-$

$7890$

ANCHOR

$\_$

ID:

$112$

FIRST

$\_$

NAME: MARSHAWN

LAST

$\_$

NAME: LYNCH

EMAIL

$\_$

ADDRESS : marshawn.lynch@nfl

$.$

com

PHONE

$\_$

NUMBER:

$890$

$-$

$456$

$-$

$7890$

Populate the SHOW table as follows

SHOW

$\_$

ID:

$10$

SHOW

$\_$

NAME: NFL NETWORK

SHOW

$\_$

GENRE: SPORTS

Populate the STUDIO table as follows

STUDIO

$\_$

ID:

$323$

STUDIO

$\_$

NAME: LOS ANGELES WEST

CITY: LOS ANGELES

Populate the BROADCAST table as follows

BROADCAST

$\_$

ID:

$1008$

BROADCAST

$\_$

DATE:

$\text{'}2022$

$-$

$08$

$-$

$30\text{'}$

START

$\_$

TIME:

$\text{'}2022$

$-$

$08$

$-$

$3017$

:

$00$

:

$00\text{'}$

$,$

END

$\_$

TIME:

$\text{'}2022$

$-$

$08$

$-$

$3018$

:

$00$

:

$00\text{'}$

STUDIO

$\_$

ID:

$323$

BROADCAST

$\_$

TITLE: ROOKIES WORKOUT

Populate the ANCHOR

$\_$

ASSIGNMENT table as follows

ANCHOR

$\_$

ID:

$13$

BROADCAST

$\_$

ID:

$1008$

ANCHOR

$\_$

ID:

$112$

BROADCAST

$\_$

ID:

$1008$

Test query

Run the following query. It should return two records.

SELECT SHOW

$\_$

NAME, BROADCAST

$\_$

TITLE, BROADCAST

$\_$

DATE, START

$\_$

TIME, END

$\_$

TIME, STUDIO.STUDIO

$\_$

CITY, FIRST

$\_$

NAME, LAST

$\_$

NAME

FROM BROADCAST

NATURAL JOIN SHOW

NATURAL JOIN STUDIO

NATURAL JOIN ANCHOR

$\_$

ASSIGNMENTS

NATURAL JOIN ANCHORP