Gce Model Questions Vol1 2023 Computer Studies Question 5

Practice essay / theory question 5 from the 2023 Gce Model Questions Vol1 Computer Studies examination. This question covers Database design, Data normalisation, SQL reporting .

Gce Model Questions Vol1 2023 Computer Studies Essay / Theory
Topics: Database design Data normalisation SQL reporting
Question 5 GCE_MODEL_QUESTIONS_VOL1 • 2023 • COMPUTER_STUDIES • essay

A secondary school is planning to implement an information system to manage student academic records. The system must store each student's personal details, enrolment information, and examination results for three terms per year.

Question Parts

( a )
Propose an appropriate relational database table structure to store the information. Identify at least three tables, specify a primary key for each, and list at least three attributes for each table.
( b )
Explain how you would apply the first three normal forms (1NF, 2NF, 3NF) to the tables you proposed, giving a concrete example of a functional dependency that would be removed at each stage.
( c )
The school wants to generate a report showing the average score per subject for each term. Outline the steps you would take to produce this report, using either pseudocode or an SQL statement, and indicate any calculations required.

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

The question covers Database design, Data normalisation, SQL reporting .

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