Multiple Choice
An auditor examined the database for Trent's Textiles Corporation. During her examination, she noticed two cash disbursements in the Cash Disbursements table had blanks (null values) in the vendor number field. Assuming no data entry error has occurred, what is the most plausible explanation for these blanks?
A) There is no plausible explanation - an error must have occurred.
B) Referential integrity was not established between Vendor and Cash Disbursement
C) The participation of Cash Disbursement in the relationship with Vendor is optional
D) The participation of Vendor in the relationship with Cash Disbursement is mandatory
E) The participation of Cash Disbursement in the relationship with Vendor is mandatory
Correct Answer:

Verified
Correct Answer:
Verified
Q8: Entity integrity refers to a primary key
Q9: Convert the following conceptual model into a
Q10: Which example relational tables contain data that
Q11: If you have two entities that are
Q12: To communicate to Microsoft Access the fact
Q14: The order in which columns are placed
Q15: What is the correct action to take
Q16: A concatenated relationship key contains fields from
Q17: The rule for converting relationships for which
Q18: In Microsoft Access, enabling the "Cascade Update