Gce Model Questions Vol1 2021 Computer Studies Question 9

Practice essay / theory question 9 from the 2021 Gce Model Questions Vol1 Computer Studies examination. This question covers Database design, Normalization, SQL query formulation, Transaction management, Data integrity .

Gce Model Questions Vol1 2021 Computer Studies Essay / Theory
Topics: Database design Normalization SQL query formulation Transaction management Data integrity
Question 9 GCE_MODEL_QUESTIONS_VOL1 • 2021 • COMPUTER_STUDIES • essay

A secondary school intends to develop a computerised library management system. The system must store information about books, members, and borrowing transactions. The design should support efficient retrieval of records and maintain data integrity.

Question Parts

( a )
Propose a relational schema that stores information about books, members and borrowing transactions. List each table, its primary key and any foreign keys. Show that the schema is in Third Normal Form (3NF) and give a brief justification for each table.
( b )
Write an SQL statement that retrieves the titles of all books that are currently borrowed by members of class ‘SS2’ and have not been returned for more than 14 days. Assume the current date is 2021‑12‑01 and the Borrowings table contains fields BorrowDate (date) and ReturnDate (date, NULL if not returned).
( c )
Explain the role of the ACID properties in ensuring reliable transaction processing for the borrowing operation. Briefly describe each property (Atomicity, Consistency, Isolation, Durability).
( d )
Identify two possible data‑integrity violations that could occur if foreign‑key constraints are not enforced in the schema. For each violation, suggest a method to prevent it.

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 Gce Model Questions Vol1 2021 Computer Studies Question 9. It is one of the essay questions from the 2021 Gce Model Questions Vol1 Computer Studies examination.

The question covers Database design, Normalization, SQL query formulation, Transaction management, Data integrity .

View More Gce Model Questions Vol1 2021 Computer Studies Questions More Gce Model Questions Vol1 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