Gce Model Questions Vol1 2025 Computer Studies Question 9

Practice essay / theory question 9 from the 2025 Gce Model Questions Vol1 Computer Studies examination. This question covers Database Management Systems, Relational Database Design, Normalization, SQL, Triggers, Data Integrity .

Gce Model Questions Vol1 2025 Computer Studies Essay / Theory
Topics: Database Management Systems Relational Database Design Normalization SQL Triggers Data Integrity
Question 9 GCE_MODEL_QUESTIONS_VOL1 • 2025 • COMPUTER_STUDIES • essay

A small retail store wants to computerise its inventory and sales records. The store sells various products, each identified by a product code, name, unit price, and category. Sales are recorded with a sale ID, date, customer ID, and details of each product sold (product code, quantity). Customers have a customer ID, name, address, and phone number.

Question Parts

( a )
Propose a set of relational tables (including primary keys) to store this information, ensuring no redundant data. Justify your design with reference to normal forms.
( b )
Write an SQL statement to retrieve the total amount spent by each customer in the month of March 2024, showing the customer name and total amount, ordered from highest to lowest total.
( c )
The store wants to ensure that a product cannot be sold if its quantity in stock falls below the quantity being sold. Explain how you would enforce this rule using database constraints or triggers. Provide a brief example of the trigger code (in SQL syntax).

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

The question covers Database Management Systems, Relational Database Design, Normalization, SQL, Triggers, Data Integrity .

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