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
Q28: The rule for converting conceptual model relationships
Q29: If you have two entities that are
Q30: Which example relational tables contain data that
Q31: Given the following set of relational database
Q32: Disregarding minimum cardinalities, when converting conceptual models
Q34: Imagine you are implementing the relationships of
Q35: For which of these relationships does an
Q36: When creating a table in Microsoft Access,
Q37: In Microsoft Access, enabling the "Cascade Update
Q38: Which of the following pieces of data
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents