Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: lbelcher on Feb 10, 2019



Title: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ...
Post by: lbelcher on Feb 10, 2019
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.


Title: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ...
Post by: Jacobian Smith on Feb 10, 2019
Content hidden


Title: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ...
Post by: lbelcher on Feb 10, 2019
Exactly what I needed for my project, TYSM