Gce Model Questions Vol1 2018 Computer Studies Question 4

Practice essay / theory question 4 from the 2018 Gce Model Questions Vol1 Computer Studies examination. This question covers Data and Information .

Gce Model Questions Vol1 2018 Computer Studies Essay / Theory

Topic: Data and Information

Question 4 GCE_MODEL_QUESTIONS_VOL1 • 2018 • COMPUTER_STUDIES • essay

A small business records its daily sales in a spreadsheet. Each record contains the fields: Transaction ID, Date, Product Code, Quantity Sold, Unit Price and Total Amount.

Question Parts

( a )

Explain how the data could be reorganised into a relational database. Specify at least two tables and identify the primary and foreign keys required.

( b )

The business wants a monthly sales report that shows total revenue for each product. Describe the steps required to produce this report using appropriate data‑manipulation techniques.

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

The question covers Data and Information .

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