Database Fundamentals — Question 113

Philandrio Inc. is one of the largest drug manufacturing companies in the world.
It has many offices worldwide. Each office has a manpower of approximately 14,000.
The managers themselves are employees in the company.
You are building a database for the company's Human Resources Department (HRD).
You want to track the following attributes for each employee, and at the same time, eliminate duplicate entries and minimize data storage wherever possible.

FirstName -

MiddleName -

LastName -

EmployeeldentityNumber -

Address -

Date_of_Hire -

Department -

Salary -

ManagerIdentityNumber -
Which of the following is the appropriate table detail sufficient to track the above attributes, correctly and efficiently?

Answer options

• A. Only one table, Employee
• B. Three tables, Employee, Manager, and a table to link both these entities
• C. Two tables, Employee and Manager
• D. Either two or three tables

Correct answer: A

Explanation

The correct answer is A because using a single table, Employee, allows for all attributes to be tracked without redundancy, given that managers are also employees. Options B and C suggest additional tables that unnecessarily complicate the structure, while D is vague and does not specify a clear solution.