Gce Model Questions Vol1 2019 Computer Studies Question 4

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

Gce Model Questions Vol1 2019 Computer Studies Essay / Theory

Topic: Data and Information

Question 4 GCE_MODEL_QUESTIONS_VOL1 • 2019 • COMPUTER_STUDIES • essay

A secondary school science department maintains a database of student laboratory experiment records. Each record includes: - Student ID (numeric, 6 digits) - Experiment Code (e.g., "CH101") - Date (dd/mm/yyyy) - Score (0‑100) - Teacher Comments (text) The department wants to improve data retrieval and ensure data integrity.

Question Parts

( a )

Propose an appropriate relational database design, specifying at least two tables, their primary keys, and the relationship between them. Explain why this design reduces redundancy.

( b )

Write an SQL query that returns, for the current term, each Experiment Code together with the average Score of all students who performed that experiment.

( c )

Discuss two data‑validation rules that should be enforced when entering a new record, and explain how each rule helps maintain data quality.

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

The question covers Data and Information .

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