Neco 2021 Data Processing Question 5

Practice essay / theory question 5 from the 2021 Neco Data Processing examination. This question covers Relational Algebra, Normalization, Transaction Management .

Neco 2021 Data Processing Essay / Theory
Topics: Relational Algebra Normalization Transaction Management
Question 5 NECO • 2021 • DATA_PROCESSING • essay

A university maintains a relational database to store information about its students, courses, lecturers and the results of examinations.

Question Parts

( a )
Write a relational algebra expression that retrieves the names of students who are enrolled in **every** course taught by Lecturer Dr. Okoro.
( b )
The current design of the database includes the following relations (attributes shown in brackets): • STUDENT(SID, SName, Dept) • LECTURER(LID, LName, Dept) • COURSE(CID, CTitle, LID) • ENROLL(SID, CID, Grade) Discuss whether each relation is in Third Normal Form (3NF). If any relation is not in 3NF, show how it can be decomposed to achieve 3NF.
( c )
During the end‑of‑semester period, the registrar performs a transaction that changes the Grade of a student for a particular course from ‘B’ to ‘A’. Explain the ACID properties of this transaction and why each is important in the context of the university database.

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 2021 Data Processing Question 5. It is one of the essay questions from the 2021 Neco Data Processing examination.

The question covers Relational Algebra, Normalization, Transaction Management .

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