Neco 2024 Data Processing Question 13

Practice objective / multiple choice question 13 from the 2024 Neco Data Processing examination.

Neco 2024 Data Processing Objective / Multiple Choice Medium Difficulty
Question 13 NECO • 2024 • DATA_PROCESSING • objective

Consider the relation STUDENT with attributes (StudentID, Name, Dept, Advisor, AdvisorPhone) and the following functional dependencies:\n\n1. StudentID \(\rightarrow\) Name, Dept, Advisor\n2. Advisor \(\rightarrow\) AdvisorPhone\n3. Dept \(\rightarrow\) Advisor\n\n(a) Determine the highest normal form (up to 3NF) that the STUDENT relation satisfies.\n(b) If it is not in 3NF, decompose the relation into a set of relations that are in 3NF while preserving the dependencies.

Answer Options

A. The STUDENT relation is in 3NF. Decomposition into 3NF: STUDENT1(StudentID, Name, Dept) and ADVISOR(Advisor, AdvisorPhone).
Correct Answer B. The STUDENT relation is in 2NF (not 3NF). Decomposition into 3NF: STUDENT1(StudentID, Name, Dept, Advisor) and ADVISOR(Advisor, AdvisorPhone).
C. The STUDENT relation is in 2NF (not 3NF). Decomposition into 3NF: STUDENT1(StudentID, Name, Dept, AdvisorPhone) and ADVISOR(Advisor, AdvisorPhone).
D. The STUDENT relation is in 1NF only. Decomposition into 3NF: STUDENT1(StudentID, Name, Dept, Advisor) and ADVISOR(Advisor, AdvisorPhone).
Correct Answer
B
Correct Option:
The STUDENT relation is in 2NF (not 3NF). Decomposition into 3NF: STUDENT1(StudentID, Name, Dept, Advisor) and ADVISOR(Advisor, AdvisorPhone).

About This Question

This is Neco 2024 Data Processing Question 13. It is one of the objective questions from the 2024 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2024 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