Query #$1$a: Using the NATURAL JOIN condition, retrieve the name of the department, the name of the project, and the location of the project for the ProductY project.

Query #$1$b: Using the NATURAL JOIN condition, retrieve the name of the department, the name of the project, and the location of the project for the ProductY project. Combine this query result with one that retrieves the name of the department, the name of the project, and the location of the project that Alicia works on$.$

Query #$2$: Using LEFT OUTER JOIN between DEPARTMENT and EMPLOYEE tables list the first and last names of employees who manage a department.

Query #$3$: 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$.$

Query #$4$: Using the INTERSECT condition, write a query that retrieves the name of the department, the name of the project, and the location of the projects that Franklin works in$.($Hint: Query #$3$ and Query #$4$ differ by the keyword$)$

Query #$5$: Write a query that retrieves the number of projects each employee works on$.$ Show each employee's first and last names alongside the number of projects each employee works on$.$ Present the list ordered alphabetically by the first name.

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$< 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: Task 1 : Relational Algebra ( 1 0 points ) Write relational algebra expressions for the following queries using the company database schema: Retrieve the name and address of employees who work for... Q: APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use... Q: APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use... 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: Specify the following queries on the given database schema using relational algebra. a ) Retrieve the SSNs and names ( Lname , Fname ) of all employees in department 4 who work more than 5 hours per... Q: Please provide SQL Query using the Schema. Retrieve the name and number of the project which uses the most employees. Also show the total number of employees for that project. If there is more than... Q: 1. Create a new database companyx, all the existing the relations implied from tables shown and populate it. 2. From the Wamp, export the PDF that shows all tables and their relations. 4 4 EMPLOYEE... Q: oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string... Q: First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and... Q: Exercise 4.1 What is the difference between a relational algebras operations degree and arity? Give an example where an operation is applied such that these two differ! Exercise 4.2 Are the following... Q: Lachgar Industries warrants its products for one year. The estimated product warranty is 4% of sales. Assume that sales were $210,000 for June. In July, a customer received warranty repairs requiring... Q: Income statement data for Montana Images Company for the years ended December 31, 2012 and 2011, are as follows: a. Prepare a comparative income statement with horizontal analysis, indicating the... Q: Eva enters into an agreement with Ron to purchase $ 5 , 0 0 0 worth of shares in Happy Supermarket Inc. before the incorporation of the Happy Supermarket. The offer is deemed accepted at the moment... Q: Determine whether each experiment is a binomial experiment or can be reduced to a binomial experiment If so describe a trial determine the random variable and state n p and q You randomly remove one... Previous Question Next Question Recommended Textbook More Books Design Operation And Evaluation Of Mobile Communications Authors: Gavriel Salvendy ,June Wei 1st Edition 3030770249, 978-3030770242 Ask a Question and Get Instant Help! Study Help Services Sitemap Fun Definitions Become Tutor Used Textbooks Study Help Categories Recent Questions Expert Questions Campus Wear Sell Your Books Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Online Quiz Give Feedback, Get Rewards Get In Touch About Us Contact Us Career Jobs FAQ Student Discount Campus Ambassador Secure Payment Download Our App © 2026 SolutionInn. All Rights Reserved $