Gce Model Questions Vol1 2022 Computer Studies Question 9

Practice essay / theory question 9 from the 2022 Gce Model Questions Vol1 Computer Studies examination. This question covers Database design, Normalization, SQL queries, Stored procedures .

Gce Model Questions Vol1 2022 Computer Studies Essay / Theory
Topics: Database design Normalization SQL queries Stored procedures
Question 9 GCE_MODEL_QUESTIONS_VOL1 • 2022 • COMPUTER_STUDIES • essay

A small retail business is developing a database to store information about its products, suppliers and sales.

Question Parts

( a )
Define the concepts of First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF). With a brief example, show how a table that is in 1NF but not in 2NF can be transformed to 2NF, and then to 3NF.
( b )
The following two tables have been created: Product(ProductID, ProductName, SupplierID, UnitPrice) Supplier(SupplierID, SupplierName, City) Write an SQL statement that lists each supplier’s name, the number of different products they supply, and the average unit price of those products. Include only suppliers that supply at least three products, and order the result by the average unit price descending.
( c )
Discuss the advantages and disadvantages of implementing data‑validation rules as stored procedures in the DBMS compared with performing the same validation in the application layer.

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

The question covers Database design, Normalization, SQL queries, Stored procedures .

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