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.

Question

Quizplus · Accepted Answer

To establish a one-to-many relationship between the Customer Information Table and the Order Information Table, the primary key from the Customer Information Table (the unique customer number) should be included as a foreign key in the Order Information Table. This allows multiple orders to be linked to a single customer.

Irene Is Working on a Database That Stores Customer Data