HomeworkLib
Question

Using Entertainment Agency Example, suppose you would like to remove all musical styles that are NOT...

Using Entertainment Agency Example, suppose you would like to remove all musical styles that are NOT played by any entertainers AND are NOT favored by any customers.

Which of the statements below would best accomplish this task?

Question 4 options:

DELETE FROM Musical_Styles
WHERE StyleID NOT IN (SELECT StyleID FROM Entertainer_Styles)
OR StyleID NOT IN (SELECT StyleID FROM Musical_Preferences)

DELETE FROM Musical_Styles
WHERE StyleID NOT IN (SELECT StyleID FROM Entertainer_Styles)
AND StyleID NOT IN (SELECT StyleID FROM Musical_Preferences)

DELETE FROM Musical_Preferences
WHERE StyleID NOT IN (SELECT StyleID FROM Musical_Styles)
AND StyleID NOT IN (SELECT StyleID FROM Entertainer_Styles)

DELETE FROM Musical_Styles
WHERE StyleID IS NULL
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Option 2 is the right answer.
Here the task is to delete all the musical styles that are NOT played by any entertainers AND are NOT favored by any customers, so for this we need to check the tables
musical preferences and entertainer styless. These are the two tabes that are used to check the two conditions that specified in the question. Nad second query satisifies
both the conditions. Initially we are checking for musical styles that are not in entertainer_styles and also musical_preferences later. Here we have used NAD to satisfy both the conditions

0 0
Add a comment
Know the answer?
Add Answer to:
Using Entertainment Agency Example, suppose you would like to remove all musical styles that are NOT...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Key Partners Key Partners of our travel agency business would be those that provides travel and...

    Key Partners Key Partners of our travel agency business would be those that provides travel and tourism related services to the public on behalf of suppliers such as activities, airlines, car rentals, cruise lines, hotels, railways, travel insurance, and package tours. Our partner would provide resources like hotel packages, tour packages, rental cars to our customers, etc which would help us to attract customers to our travel agency. Our partner would perform activities like contacting and arranging the accommodation facilities...

  • QUESTION 27 Suppose you would like to estimate the proportion of all DCC students whose permanent...

    QUESTION 27 Suppose you would like to estimate the proportion of all DCC students whose permanent residence is outside Duchess County from those living in Cork in the dorm) a) pows) Do you think the sample will be representative of DXCC students? Why or why not? You select a random sample of 75 students b) ponts) Do you think the sampling method would everestimate the true population parameter underestimate the true population parameter, or accurately target the population parameter? Explain

  • This homework problem has me pulling my hair out. We are working with text files in Java using Ne...

    This homework problem has me pulling my hair out. We are working with text files in Java using NetBeans GUI application. We're suppose to make a movie list and be able to pull up movies already in the text file (which I can do) and also be able to add and delete movies to and from the file (which is what I'm having trouble with). I've attached the specifications and the movie list if you need it. Any help would...

  • Question 2 0/1 point (graded) What happens when you remove a directory using the command rm...

    Question 2 0/1 point (graded) What happens when you remove a directory using the command rm -r? You cannot remove a directory using the rm command. You permanently remove the entire directory, including all files and subdirectories. You move the entire directory to a trash folder, but it can be restored later. You get a warning message asking if you want to proceed, then you delete the directory. incorrect Answer Incorrect: Try again. Unix does not warn you before permanently...

  • C++ Assignment Project 1 - NodeList Building upon the the ListNode/List code I would like you...

    C++ Assignment Project 1 - NodeList Building upon the the ListNode/List code I would like you to extend the interface of a list to have these member functions as well. struct ListNode { int element; ListNode *next; } Write a function to concatenate two linked lists. Given lists l1 = (2, 3, 1)and l2 = (4, 5), after return from l1.concatenate(l2)the list l1should be changed to be l1 = (2, 3, 1, 4, 5). Your function should not change l2and...

  • USING Java, create a program with the following: (I would like a different answer than the...

    USING Java, create a program with the following: (I would like a different answer than the answer on a similar question asked from someone else) 1-The first class is an abstract class called Weapon: a-Weapon has two different abstract methods: i-The first abstract method is void and is called attackType ii-The second abstract method is void and is called range b-Weapon has a constructor that accepts the weaponName c-Weapon also has a regular method that calculatesDamange and takes in attackType...

  • C++ Assignment Project 1 - NodeList Building upon the the ListNode/List code I would like you to extend the interface of...

    C++ Assignment Project 1 - NodeList Building upon the the ListNode/List code I would like you to extend the interface of a list to have these member functions as well. struct ListNode { int element; ListNode *next; } Write a function to concatenate two linked lists. Given lists l1 = (2, 3, 1)and l2 = (4, 5), after return from l1.concatenate(l2)the list l1should be changed to be l1 = (2, 3, 1, 4, 5). Your function should not change l2and...

  • PART ONE: REPORT (BSBCUS402 BSBRES401) Choose one (1) australian company that you would like to work for and choose one...

    PART ONE: REPORT (BSBCUS402 BSBRES401) Choose one (1) australian company that you would like to work for and choose one (1) type of product or service that they offer in your chosen field of expertise. Using the research skills, you garnered in your undergraduate study, collect, organise, interpret & analyse the following customer service information from your chosen company into a professional report. You may wish to interview someone who is working in this company as a part of your...

  • You will develop an E-Commerce database used to maintain customers, products and sales information. You are...

    You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database 3) create stored procedures to develop the tables and insert the data 4) write SQL statements for data extraction and reporting. Throughout the course of this semester you have analyzed the requirements for an eCommerce database, designed and developed your database. As a class we have gone through the process...

  • The lab for this week addresses taking a logical database design (data model) and transforming it...

    The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT