Neco 2022 Data Processing Question 48

Practice objective / multiple choice question 48 from the 2022 Neco Data Processing examination.

Neco 2022 Data Processing Objective / Multiple Choice Medium Difficulty
Question 48 NECO • 2022 • DATA_PROCESSING • objective

A relation EMP has attributes (EmpID, DeptID, DeptName, ManagerID, ManagerName) with the functional dependencies: \(EmpID \rightarrow DeptID\), \(DeptID \rightarrow DeptName\), \(ManagerID \rightarrow ManagerName\), \(DeptID \rightarrow ManagerID\). Determine the highest normal form of EMP and give a lossless‑decomposition into tables that achieve that normal form, specifying the attributes and primary key of each resulting table.

Answer Options

Correct Answer A. Highest normal form: 2NF. Decomposition: EMP1(EmpID, DeptID) with primary key EmpID; DEPT(DeptID, DeptName, ManagerID) with primary key DeptID; MANAGER(ManagerID, ManagerName) with primary key ManagerID.
B. Highest normal form: 3NF. Decomposition: EMP1(EmpID, DeptID, DeptName) with primary key EmpID; DEPT(DeptID, ManagerID) with primary key DeptID; MANAGER(ManagerID, ManagerName) with primary key ManagerID.
C. Highest normal form: 1NF. Decomposition: EMP1(EmpID, DeptID) with primary key EmpID; DEPT(DeptID, DeptName) with primary key DeptID; MANAGER(ManagerID, ManagerName) with primary key ManagerID.
D. Highest normal form: BCNF. Decomposition: EMP1(EmpID, DeptID) with primary key EmpID; DEPT(DeptID, DeptName, ManagerID) with primary key ManagerID; MANAGER(ManagerID, ManagerName) with primary key ManagerName.
Correct Answer
A
Correct Option:
Highest normal form: 2NF. Decomposition: EMP1(EmpID, DeptID) with primary key EmpID; DEPT(DeptID, DeptName, ManagerID) with primary key DeptID; MANAGER(ManagerID, ManagerName) with primary key ManagerID.

About This Question

This is Neco 2022 Data Processing Question 48. It is one of the objective questions from the 2022 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2022 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support