Using the MINUS condition, write a query that retrieves the name of the department, the name of the project, and the location of projects that Franklin does not work in$.$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$)$

$)$;

$--$Populate$$ANCHOR$$table

INSERT$$INTO$$ANCHOR$($ANCHOR$\_$ID$,$FIRST$\_$NAME,$$LAST$\_$NAME,$$EMAIL$\_$ADDRESS,$$PHONE$\_$NUMBER$)$

VALUES$$

$(13,\text{'}$KURT$\text{'},\text{'}$WARNER$\text{'},\text{'}$kurt$.$warner@nfl$.$com',$\text{'}890-013-7890\text{'}),$

$(112,\text{'}$MARSHAWN$\text{'},\text{'}$LYNCH$\text{'},\text{'}$marshawn$.$lynch@nfl$.$com',$\text{'}890-456-7890\text{'})$;

$--$Populate$$SHOW$$table

INSERT$$INTO$$SHOW$($SHOW$\_$ID$,$SHOW$\_$NAME,$$SHOW$\_$GENRE$)$

VALUES$(10,\text{'}$NFL$$NETWORK$\text{'},\text{'}$SPORTS$\text{'})$;

$--$Populate$$STUDIO$$table

INSERT$$INTO$$STUDIO$($STUDIO$\_$ID$,$STUDIO$\_$CITY,$$STUDIO$\_$NAME$)$

VALUES$(323,\text{'}$LOS$$ANGELES$\text{'},\text{'}$LOS$$ANGELES$$WEST$\text{'})$;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Using SQL developer 1. Write a query to print department names and their full address of the location in column, if the department is located in UK. (5 points) Ex) Address 8204 Arthur St, London UK...

Q:

Total Points: 1 0 0 Write the code for each of the following and submit a textfile with the scripts in the DropBox for the assignment in Moodle. Questions 1 - 5 are each worth 8 points and Questions...

Q:

CS 2 4 4 3 SQL Server Assignment 7 Total Points: 1 0 0 Write the code for each of the following and submit a textfile with the scripts in the DropBox for the assignment in Moodle. Questions 1 - 5 are...

Q:

Assume that you have the following tables in a database: Workers Name SSH Married (Boolean True/False) Dept (Department Name) Salary BDay (Birth Day Date Field) Name (Name of department) ManagerName...

Q:

Only use whats discussed in class. You can not use if its not listed below: SELECT FROM WHERE GROUP BY HAVING ORDER BY LIKE SUM AVG COUNT LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN >= > SOME...

Q:

Have the Queries in this order SELECT FROM WHERE GROUP BY HAVING ORDER BY CAN ONLY USE WHAT IS COVERED IN CLASS. SEE BELOW: (CAN NOT USE DISTINCT YET) SELECT FROM WHERE GROUP BY HAVING ORDER BY LIKE...

Q:

Assume that you have the following tables in a database: Workers Name SSH Married (Boolean True/False) Dept (Department Name) Salary BDay (Birth Day Date Field) Name (Name of department) ManagerName...

Q:

This task has five parts. IMPORTANT: If you do not complete this step, your work will not be graded at all. You will get a zero for the project. Create a company database named as COMP _ your first...

Q:

QUESTION 1: Given the following schema above write a sequence of relational algebra expressions for the following queries: Note: In the DEPT_LOCATIONS relation, Dlocation attribute represents the...

Q:

This is the picture of the information to start the assignment. Need a lot of help please and need the workbook for excel once done. This is the picture of the information to start the assignment....

Q:

What does the empirical evidence on the consumption-smoothing benefits of UI indicate about the degree to which individuals are, on average, insured against the income losses associated with...

Q:

What is meant by the term sentence completion exercise? Give an example.

Q:

Which of the following is / are diversifiable risk factors for Boeing shareholders? Select all that apply. Multiple answers:Multiple answers are accepted for this question Select one or more answers...

Q:

What part of the Constitution discusses political parties? Question 3 options: The Constitution does not discuss political parties the Preamble Article 1 The 16th Amendment

Previous Question Next Question