Neco 2019 Data Processing Question 5

Practice essay / theory question 5 from the 2019 Neco Data Processing examination. This question covers Database Management Systems, Relational Algebra, Normalization, Functional Dependencies .

Neco 2019 Data Processing Essay / Theory
Topics: Database Management Systems Relational Algebra Normalization Functional Dependencies
Question 5 NECO • 2019 • DATA_PROCESSING • essay

A university maintains a relational database to store information about its students, courses and enrolments. The schema consists of three relations: STUDENT(SID, Name, Dept, Level) ENROLL(SID, CourseCode, Semester, Grade) COURSE(CourseCode, Title, Credits, Dept) The following functional dependencies are known: - In STUDENT: SID → Name, Dept, Level - In COURSE: CourseCode → Title, Credits, Dept - In ENROLL: (SID, CourseCode, Semester) → Grade - In ENROLL: SID → Dept (each student belongs to a single department) Using this information, answer the questions below.

Question Parts

( a )
Identify all candidate keys for each of the three relations STUDENT, COURSE and ENROLL.
( b )
Write a relational algebra expression that retrieves the names of all students who have obtained a grade ‘A’ in any course that is offered by the Computer Science department.
( c )
The relation ENROLL is currently in Second Normal Form (2NF). Using the functional dependencies given, determine whether ENROLL is also in Third Normal Form (3NF). Justify your answer.
( d )
Explain two advantages of enforcing foreign‑key constraints between ENROLL.SID and STUDENT.SID, and between ENROLL.CourseCode and COURSE.CourseCode.

Detailed Solution & Marking Scheme

Get the step-by-step solution, key points required by examiners and detailed marking guidance through the Edcrib AI Tutor.

Reveal Answer

About This Question

This is Neco 2019 Data Processing Question 5. It is one of the essay questions from the 2019 Neco Data Processing examination.

The question covers Database Management Systems, Relational Algebra, Normalization, Functional Dependencies .

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