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:

Crash Duration

The shortest possible time for which an activity or project phase can be scheduled after allocating the maximum amount of resources.

Total Cost

The complete cost of producing or acquiring goods or services, including variable costs, fixed costs, and any other relevant expenses.

Network Diagram

A visual representation of a project's activities and their interdependencies, often used to plan and monitor project timelines.

Expected Duration

The anticipated amount of time which will elapse before a particular project or activity is completed.