Ask a Question
  
  
  
Top Posters
Since Sunday
26
15
11
10
9
9
9
8
8
7
7
7
New Topic  
wrote...
Posts: 44
A week ago
You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity constraint:

SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber

You run the following SQL query:

SELECTCustomerNumber
FROMSALE
WHERECustomerNumber NOT IN
(SELECTCustomerNumber
FROMCUSTOMER);

What is shown in the results of this query?

• All values of CustomerNumber that match the constraint.

• All values of CustomerNumber that violate the constraint.

• All values of CustomerNumber where
SALE.CustomerNumber = CUSTOMER.CustomerNumber.

• All values of Customer number that are in CUSTOMER but not in SALE.
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 6 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 21
Rep: 2 0
A week ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
All values of CustomerNumber that violate the constraint.
1
Related Topics
wrote...
A week ago
Exactly what I needed for my project, TYSM
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  73 People Browsing
 123 Signed Up Today
Related Images
 809
 59
 74
Your Opinion