Irene Is Working on a Database That Stores Customer Data

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.