Q17 Relational Algebra 30 Points NETWORK SHOW NetworkID N_Name 1 NBC 2 CBS SName NID Superstore 1 Transplant 1 Stand 2 Clarice 2. Genre Comedy Drama Horror Drama Show.NID is a foreign key to the NetworkID column in Network Relation. This is an example of data in these tables. Your work should not assume this state. Text is Case-Insensitive Q171 RA. 5 Points Write the relational algebra to return Sname and NID of all shows that are of the Horror genre. Enter your answer here Q17.2 5 Points Write the tuple calculus to return Sname and NID of all shows that are of the Horror genre. Enter your answer here or Please select file(s) Select file(s) Q173 RA 5 Points Write the relational algebra to return the show name, and the name of the network the show is on. Enter your answer here or Please select file(s) Select file(s) Q17.4 TC 5 Points Write the tuple calculus to return the show name, and the name of the network the show is on Enter your answer here Q17.5 RA 5 Points Write the relational algebra to return the NetworkID and the network name of networks that do not have any shows. Enter your answer here or Please select file(s) Select file(s) 217.6 RA 5 Points Write the relational algebra to return the # of shows by genre. It should just return genre and a count of how many shows are in each genre. Enter your answer here or Please select file(s) Select file(s) Q17 Relational Algebra 30 Points NETWORK SHOW NetworkID N_Name 1 NBC 2 CBS SName NID Superstore 1 Transplant 1 Stand 2 Clarice 2. Genre Comedy Drama Horror Drama Show.NID is a foreign key to the NetworkID column in Network Relation. This is an example of data in these tables. Your work should not assume this state. Text is Case-Insensitive Q171 RA. 5 Points Write the relational algebra to return Sname and NID of all shows that are of the Horror genre. Enter your answer here Q17.2 5 Points Write the tuple calculus to return Sname and NID of all shows that are of the Horror genre. Enter your answer here or Please select file(s) Select file(s) Q173 RA 5 Points Write the relational algebra to return the show name, and the name of the network the show is on. Enter your answer here or Please select file(s) Select file(s) Q17.4 TC 5 Points Write the tuple calculus to return the show name, and the name of the network the show is on Enter your answer here Q17.5 RA 5 Points Write the relational algebra to return the NetworkID and the network name of networks that do not have any shows. Enter your answer here or Please select file(s) Select file(s) 217.6 RA 5 Points Write the relational algebra to return the # of shows by genre. It should just return genre and a count of how many shows are in each genre. Enter your answer here or Please select file(s) Select file(s)
