Gce Model Questions Vol1 2024 Computer Studies Question 5

Practice essay / theory question 5 from the 2024 Gce Model Questions Vol1 Computer Studies examination. This question covers Database Design, Normalization, Relational Database .

Gce Model Questions Vol1 2024 Computer Studies Essay / Theory

Topics: Database Design Normalization Relational Database

Question 5 GCE_MODEL_QUESTIONS_VOL1 • 2024 • COMPUTER_STUDIES • essay

A small retail shop wants to computerise its inventory management. The shop records each sale with the following information: Transaction ID, Date, Product Code, Product Description, Unit Price, Quantity Sold, Total Sale Amount, Supplier Name, Supplier Contact, and Stock Level after the sale. The owner wants the data stored in a relational database that avoids redundancy and supports easy updating of product and supplier details.

Question Parts

( a )

List the functional dependencies that exist among the attributes given in the scenario.

( b )

Using the functional dependencies, decompose the data into tables that are in Third Normal Form (3NF). State the primary key for each table.

( c )

Explain two advantages of storing the data in the 3NF structure you have proposed.

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

The question covers Database Design, Normalization, Relational Database .

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