In the context of journal entries and the use of primary keys in accounting tables, if 'Customer ID' is the primary key in a customer table, which field should be moved to a separate table to maintain proper database normalization?

• A. Customer Address
• B. Customer Phone Number
• C. Order Details
• D. Customer Name

Answer: (C)

Verified step by step guidance

1. Understand the concept of database normalization: Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves dividing large tables into smaller ones and defining relationships between them.
2. Identify the primary key: In this problem, 'Customer ID' is the primary key in the customer table. A primary key uniquely identifies each record in a table.
3. Analyze the fields provided: The fields 'Customer Address,' 'Customer Phone Number,' and 'Customer Name' are directly related to the customer and should remain in the customer table. These fields describe the customer and are dependent on the 'Customer ID.'
4. Consider the field 'Order Details': This field is not directly related to the customer but rather to the transactions or orders made by the customer. To maintain proper normalization, 'Order Details' should be moved to a separate table, as it represents a different entity (orders) and can be linked to the customer table using 'Customer ID' as a foreign key.
5. Establish relationships between tables: Create a separate 'Orders' table with 'Order Details' and include 'Customer ID' as a foreign key to link it to the customer table. This ensures proper normalization and avoids redundancy in the database structure.