Neco 2017 Computer Studies Question 5

Practice essay / theory question 5 from the 2017 Neco Computer Studies examination. This question covers Database design, Normalization, SQL queries, Data management .

Neco 2017 Computer Studies Essay / Theory
Topics: Database design Normalization SQL queries Data management
Question 5 NECO • 2017 • COMPUTER_STUDIES • essay

A small retail business records its sales transactions in a single table as shown below. Fields: TransactionID, Date, CustomerName, ProductCode, ProductDescription, Quantity, UnitPrice, TotalAmount. The table contains many rows where the same customer purchases several products on the same date. Answer the following questions:

Question Parts

( a )
Identify a suitable primary key for the table and justify your choice.
( b )
The table suffers from redundancy. Normalise the table to Third Normal Form (3NF). Show the resulting tables with their fields, and indicate the primary key(s) and any foreign key(s).
( c )
Using the normalized tables, write an SQL statement to list the total amount spent by each customer in the month of March 2022, ordered from highest to lowest total.
( d )
Explain two advantages of storing the data in the normalized form rather than the original single table.

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 Neco 2017 Computer Studies Question 5. It is one of the essay questions from the 2017 Neco Computer Studies examination.

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

View More Neco 2017 Computer Studies Questions More Neco 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