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

EmployeeIdentityNumber

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?

Question

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
EmployeeIdentityNumber
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?

Accepted Answer

A. Only one table, Employee

Answer

B. Three tables, Employee, Manager, and a table to link both these entities

Answer

C. Two tables, Employee and Manager

Answer

D. Either two or three tables

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…

Question

Options

How the community answered

Community Discussion