Neco 2022 Computer Studies Question 5

Practice essay / theory question 5 from the 2022 Neco Computer Studies examination. This question covers Database Design, Normalization .

Neco 2022 Computer Studies Essay / Theory

Topics: Database Design Normalization

Question 5 NECO • 2022 • COMPUTER_STUDIES • essay

A secondary school intends to computerise its library management system. The system must record each book, the members who borrow books, and the dates of borrowing and return. The following attributes are proposed for the single table to be created: BookID, Title, Author, Publisher, MemberID, MemberName, Class, DateBorrowed, DateReturned, FineAmount. The school wants the database to be efficient and to avoid data anomalies. Answer the following:

( a )

Identify a suitable primary key for the table and justify your choice.

( b )

Convert the proposed table into Second Normal Form (2NF). List the resulting tables with their attributes and indicate the primary key of each table.

( c )

Explain two advantages of storing the data in 2NF for the library system.

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

This is Neco 2022 Computer Studies Question 5. It is one of the essay questions from the 2022 Neco Computer Studies examination.

The question covers Database Design, Normalization .

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