Gce Model Questions Vol1 2020 Computer Studies Question 5

Practice essay / theory question 5 from the 2020 Gce Model Questions Vol1 Computer Studies examination. This question covers Computer hardware and software components, Database design and normalization, Cloud computing versus local deployment .

Gce Model Questions Vol1 2020 Computer Studies Essay / Theory
Topics: Computer hardware and software components Database design and normalization Cloud computing versus local deployment
Question 5 GCE_MODEL_QUESTIONS_VOL1 • 2020 • COMPUTER_STUDIES • essay

A secondary school is planning to introduce a computer‑based library management system to replace its current manual registers.

Question Parts

( a )
Identify and briefly explain the three fundamental components of a computer system, giving one specific example of each component as it would be used in the library system.
( b )
The school wishes to keep records of books, members and loan transactions.
( ) Propose at least five fields for the Book entity, three fields for the Member entity and four fields for the Loan entity. State a primary key for each entity and justify why it uniquely identifies a record.
( ) Using the fields you have identified, normalise the data to 3NF. Show each resulting table, its fields, primary key and any foreign keys that link the tables.
( c )
The school is considering whether to host the library system on a local server in the computer laboratory or to use a cloud‑based service. Discuss two advantages and two disadvantages of moving the system to the cloud, supporting each point with a brief explanation relevant to the school environment.

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

The question covers Computer hardware and software components, Database design and normalization, Cloud computing versus local deployment .

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