Irene Is Working on a Database That Stores Customer Data

question 93

Multiple Choice

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?

• A) Irene should include the primary key in the customer information table as a foreign key in the order information table.
• B) Irene should include the foreign key in the customer information table as a primary key in the order information table.
• C) Irene should include the primary key in the customer information table as a primary key in the order information table.
• D) Irene cannot establish a relationship between the two tables.

---

Definitions:

Probability

The measure of the likelihood that an event will occur, expressed between 0 and 1.

Expected Utility Maximizer

An economic agent who selects the option with the highest expected utility, reflecting their preferences and risk tolerance.

Natural Log

The logarithm to the base \(e\), where \(e\) is an irrational and transcendental constant approximately equal to 2.71828.

Probability

A measure of the likelihood of a given event happening, often expressed as a number between 0 and 1.