Names of all the employees with all their customers

Assignment Help Computer Engineering
Reference no: EM132218892

Consider the following relational schema: employee(empId, empName, empDept) customer(custId, custName, salesRepId, rating) salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer.

What does the following query return? SELECT empName FROM employee E WHERE NOT EXISTS (SELECT custId FROM customer C WHERE C.salesRepId = E.empId AND C.rating <> `GOOD`);

(A) Names of all the employees with at least one of their customers having a ‘GOOD' rating.

(B) Names of all the employees with at most one of their customers having a ‘GOOD' rating.

(C) Names of all the employees with none of their customers having a ‘GOOD' rating.

(D) Names of all the employees with all their customers having a ‘GOOD' rating.

Reference no: EM132218892

Questions Cloud

Instantiate the two vehicle objects and display the objects : Create a class named Vehicle that acts as a superclass for vehicle types.
Generate and returns a code table for a given symbol count : Write a function gen_code_table(symb_cnt_table, offset)that generates and returns a code table for a given symbol count table, with the specified offset.
Explain where you would get the information to address : The preparation of a formal SEMP is usually a required portion of a contractor's proposal for a competitive system development program.
How many computers will be attached to the network : What kind of networking device is easiest to reconfigure? What kind offers the best access to the network medium's bandwidth between pairs of devices?
Names of all the employees with all their customers : Consider the following relational schema: employee(empId, empName, empDept) customer(custId, custName, salesRepId, rating) salesRepId is a foreign key.
Design an adt for a one-person guessing game : Design an ADT for a one-person guessing game that chooses n random integers in the range from 1 to m and asks the user to guess them.
Evaluate the impact of e-business strategies : COIT20250: Formulate and critically evaluate the impact of e-business strategies on organisational processes and outcomes.
Calculate the total medicare tax : Paul Robinson's filing status is married filing jointly, and he has earned gross pay of $2,850. Each period he makes a 403(b) contribution of 6.5% of gross pay.
What basis will she take in the property received : Jonna is a one-fourth partner in Andersen Partners. At the end of the year, her tax basis in her tax basis in her partnership interest was $25,000.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Display a centimeters- to- inches conversion table

Write a program to display a centimeters- to- inches conversion table. The smallest and largest number of centimeters in the table are input values.

  What is the impact of the problem

What is the impact of the problem? That is, how are the victims (field of study, researchers, practitioners, industry, civilians, etc.) negatively affected.

  Similarities between asymmetric and symmetric encryption

Examine the fundamental differences and similarities between asymmetric and symmetric encryption. Recommend one (1) application for which each encryption method

  Which there are 200 total unites available in the system

A system has five active processes(A-E) and one type of resource, that there are 200 total unites available in the system. the current state of the system is shown in the table below.

  Supply getmethods and setmethods for each variable

offer getmethods and setmethods for each variable. This constructor then sets the class variables miles and gas to the respective input parameters, inputmiles and inputgas.

  Factors limiting use of personalization

Two key factors limiting use of the personalization to more precisely target marketing efforts to individual customers are? Matching profiles with the product offerings and delivering those offerings.

  Ways that virtualization is accomplished using software

Can you explain one or two ways that virtualization is accomplished using software and hardware

  Write a program that inputs the number of coupons you win

Write a program that inputs the number of coupons you win and outputs how many candy bars and gumballs you can get if you spend all of coupons on candy bars.

  Knowledge of agency level enterprise operating systems

information of advanced Relational Database management Systems (RDMS) operating over a wide-area network. (note: Please explain RDMS operating over a WAN.)

  What are the three ways in which technology has affected

increased competition is forcing businesses to become lean and at the same time attract the best employees. one of the

  How can you use technology to facilitate teams

How can you use technology to facilitate teams and manage people remotely? How do you manage interpersonal conflict in a remote workforce?

  Design class called dog which keeps track of the dog''s name

design class called Dog which keeps track of the dog's name, breed, age, and license fee. The license fee will be a set amount: $12.25, since you only need one copy of this in memory, make it static. Include a method which prompts a user to set th..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd