Gce Model Questions Vol1 2017 Computer Studies Question 9

Practice essay / theory question 9 from the 2017 Gce Model Questions Vol1 Computer Studies examination. This question covers Database design, Normalization, SQL queries, Transaction management .

Gce Model Questions Vol1 2017 Computer Studies Essay / Theory
Topics: Database design Normalization SQL queries Transaction management
Question 9 GCE_MODEL_QUESTIONS_VOL1 • 2017 • COMPUTER_STUDIES • essay

A small retail shop maintains a database to record sales transactions. The current logical design uses a single table named SALES with the following attributes: TransactionID, Date, CustomerName, CustomerAddress, ProductCode, ProductDescription, UnitPrice, Quantity, TotalPrice, SalespersonID, SalespersonName, StoreLocation. The functional dependencies that apply are: - TransactionID → Date, CustomerName, CustomerAddress, SalespersonID, SalespersonName, StoreLocation - ProductCode → ProductDescription, UnitPrice - (TransactionID, ProductCode) → Quantity, TotalPrice - SalespersonID → SalespersonName Based on this information, answer the questions below.

Question Parts

( a )
Normalize the SALES table to Third Normal Form (3NF). In your answer:
( b )
Write an SQL statement that returns, for a given month (e.g., March 2023), the total sales amount for each StoreLocation, ordered from the highest to the lowest total.
( c )
Discuss two advantages of using transactions that obey the ACID properties when recording a sale in this 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 Gce Model Questions Vol1 2017 Computer Studies Question 9. It is one of the essay questions from the 2017 Gce Model Questions Vol1 Computer Studies examination.

The question covers Database design, Normalization, SQL queries, Transaction management .

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