Gce Model Questions Vol1 2025 Computer Studies Question 5

Practice essay / theory question 5 from the 2025 Gce Model Questions Vol1 Computer Studies examination. This question covers Database design, Relational databases, Data normalization, Data backup and recovery .

Gce Model Questions Vol1 2025 Computer Studies Essay / Theory

Topics: Database design Relational databases Data normalization Data backup and recovery

Question 5 GCE_MODEL_QUESTIONS_VOL1 • 2025 • COMPUTER_STUDIES • essay

A small retail business, GreenMart, plans to replace its current flat‑file inventory system with a computerised relational database. The manager has supplied a sample table that records each stock item as follows: ItemID, ItemName, SupplierName, SupplierAddress, Category, Quantity. The business also wants to ensure that data is protected against loss.

Question Parts

( a )

State three advantages of using a relational database rather than a flat‑file system for GreenMart’s inventory records.

( b )

Explain how the supplied table can be normalised to Third Normal Form (3NF). Use the fields provided to illustrate each normalisation step (1NF, 2NF, 3NF).

( c )

Recommend two backup strategies suitable for GreenMart and justify why each would be appropriate for the business.

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

The question covers Database design, Relational databases, Data normalization, Data backup and recovery .

View More Gce Model Questions Vol1 2025 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