Question

An employee database is maintained for a company. The following describes one of the tables:

Employee(EmployeeID, Name, Department, Start date, Social Security number)
Which of the following is true?

A. EmployeeID is functionally dependent on Name.
B. Start date is functionally dependent on Social Security number.
C. Social Security number is functionally dependent on Name.
D. Department is functionally dependent on employeeID.

Answer 1

EmployeeID is functionally dependent on Name in the employee database.

Step-by-step explanation:

In this employee database table, the functional dependencies can be determined by identifying the attributes that depend on each other.

• A. EmployeeID is functionally dependent on Name. This means that for each employee, there is a unique name associated with their ID.
• B. Start date is NOT functionally dependent on Social Security number. The start date can be independent of an employee's social security number.
• C. Social Security number is NOT functionally dependent on Name. The social security number is a unique identifier independent of an employee's name.
• D. Department is functionally dependent on employeeID. Each employee is assigned to a department based on their employee ID.

Therefore, the correct answer is A. EmployeeID is functionally dependent on Name.