To answer the following questions, refer to the database below.
-The following statements regarding the Vendor Orders table above are true except
A)The database does not break the referential integrity rule.
B)The database requires a PO number and an item number to add a vendor record.
C)Deleting a vendor will also delete inventory information.
D)The database requires entering the same vendor contact information multiple times.

Question

To answer the following questions, refer to the database below. 
-The following statements regarding the Vendor Orders table above are true except
A)The database does not break the referential integrity rule. 
B)The database requires a PO number and an item number to add a vendor record. 
C)Deleting a vendor will also delete inventory information. 
D)The database requires entering the same vendor contact information multiple times.

Quizplus · Accepted Answer

The database does not break the referential integrity rule because the Vendor Orders table has a foreign key constraint on the VendorID column that references the VendorID column in the Vendors table. This means that a vendor record cannot be deleted from the Vendors table if there are any vendor orders associated with that vendor in the Vendor Orders table.

To Answer the Following Questions, Refer to the Database Below