Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database
What will be an ideal response?
Answer: One-to-one: In this relationship, for each record in one table there is one record in the related table. This is a desirable relationship in a relational database.
One-to-many: In this relationship, for each record in one table there are multiple records in the related table. This is a desirable relationship in a relational database.
Many-to-many: In this relationship, multiple records in one table relate to multiple records in the related table. This is an undesirable relationship in a relational database.
You might also like to view...
Hamilton Laundry purchased $7,000 worth of supplies on June 2 and recorded the purchase as an asset. On June 30, an inventory of the supplies indicated only $1,000 on hand. The adjusting entry that should be made by the company on June 30 is
A. debit supplies Expense and credit Supplies for $6,000 B. debit Supplies Expense and credit Supplies for $1,000 C. debit Supplies and credit Supplies Expense for $1,000 D. debit Supplies and credit Supplies Expense for $6,000
Which of the following is not a major benefit of the World Wide Web to a small retailer?
a. the ability to receive orders and inquiries on a 24/7 basis b. the ability to reach distant customers, including foreign ones c. the ability to reach all potential customers d. the ability to project a large presence on the Web