In an entity relationship diagram for the general ledger, each journal entry includes a foreign key field for the Employee_ID of the employee who both posted and approved the transaction. Which of the following statements concerning the Employee_ID field used in this context is TRUE?
A) The Employee_ID field is not enough information. The transaction should also include the employees' names and departments to allow auditors to complete their review.
B) The Employee_ID would be a good candidate key for the primary key of the JournalEntry table listing each entry in the general ledger.
C) Additional employee information required can be pulled from the Employee table as the Employee_ID field is a foreign key related to the Employee table inserted into the JournalEntry table.
D) All of these answer choices are correct.

Question

Quizplus · Accepted Answer

The Employee_ID field, being a foreign key, links the JournalEntry table to the Employee table, allowing for the retrieval of additional employee information as needed without storing it directly in the JournalEntry table. This maintains database normalization by avoiding redundancy and ensuring data integrity.

In an Entity Relationship Diagram for the General Ledger, Each