Multiple Choice
On average, 99 out of 100 sales have related cash receipts (there is usually 1 sale out of 100 that either results in a sale return or becomes a bad debt) . On average, 45 out of 100 cash receipts are related to sales (the company also generates revenue through rentals, which it keeps track of in a separate entity set; 50 out of 100 of its cash receipts result from those rentals, the other 5 out of 100 result from financing events) . Considering both redundancy and load, which of the following would be the best relational table implementation solution?
A) Make a sale table, a cash receipt table, and a table for the relationship.
B) Make a sale table, a cash receipt table, and post the key of sale into the cash receipt table.
C) Make a sale table, a cash receipt table, and post the key of cash receipt into the sale table.
D) Both A and B are equally good solutions.
E) Both A and C are equally good solutions.
Correct Answer:

Verified
Correct Answer:
Verified
Q2: In relational database design, the definition of
Q3: You will be able to join two
Q4: Describe the two ways in which the
Q5: What is the first step in converting
Q6: Disregarding minimum cardinalities, when converting conceptual models
Q7: In the relational database model each table
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