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:

Perceived Benefits

The advantages or improvements believed to be associated with a product or service from the consumer's perspective.

Purchase Price

The amount paid to buy a product or service, which can include additional costs such as taxes, shipping, and handling.

Competitive Strategy

A plan that businesses use to gain an advantage over their rivals in the market, typically by differentiating their products or services, or offering lower prices.