Gce Model Questions Vol1 2021 Computer Studies Question 4

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

Gce Model Questions Vol1 2021 Computer Studies Essay / Theory

Topic: Data and Information

Question 4 GCE_MODEL_QUESTIONS_VOL1 • 2021 • COMPUTER_STUDIES • essay

A small retail business collects daily sales data for five products (A, B, C, D, E) over a week. The data are recorded in the table below. | Day | A | B | C | D | E | |----------|---|---|---|---|---| | Monday | 30| 20| 15| 10| 5 | | Tuesday | 25| 22| 18| 12| 8 | | Wednesday| 28| 18| 20| 15| 7 | | Thursday | 32| 24| 22| 14| 9 | | Friday | 35| 26| 25| 18|10 | | Saturday | 40| 30| 28| 20|12 | | Sunday | 38| 28| 27| 19|11 | All figures represent the number of units sold.

Question Parts

( a )

Calculate the total weekly sales for each product and identify the best‑selling product.

( b )

Using the weekly totals, compute the percentage contribution of each product to the overall sales. Show your working.

( c )

The owner wants to store this information in a relational database. Design a simple database schema (tables, fields, primary keys) that could accommodate daily sales records for any number of products and days. Explain how your design avoids data redundancy.

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

The question covers Data and Information .

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