98-364 Exam - Question 162

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 -

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?

Examice · Accepted Answer

To efficiently track the attributes of each employee while minimizing duplication and data storage, keeping a single table, Employee, is sufficient. This table can include columns for FirstName, MiddleName, LastName, EmployeeIdentityNumber, Address, Date_of_Hire, Department, Salary, and ManagerIdentityNumber. By including the ManagerIdentityNumber in the same table, it is possible to represent the relationship between employees and their managers without needing additional tables. This approach minimizes complexity and avoids redundancy within the database schema.

robertscobar · Answer

3 table is lowest space used.

98-364 Exam - Question 162

Discussion