Neco 2017 Data Processing Question 5

Practice essay / theory question 5 from the 2017 Neco Data Processing examination. This question covers Relational schema, Primary and foreign keys, Normalization, SQL query formulation, Indexing, ACID properties .

Neco 2017 Data Processing Essay / Theory
Topics: Relational schema Primary and foreign keys Normalization SQL query formulation Indexing ACID properties
Question 5 NECO • 2017 • DATA_PROCESSING • essay

TechGear Ltd maintains a relational database to record its product inventory and sales transactions. The database stores information about products, customers, orders and the items contained in each order.

Question Parts

( a )
List the relational schema for the entities Product, Customer, Order and OrderItem. For each table indicate the primary key and any foreign keys.
( b )
For the OrderItem table, determine the highest normal form it satisfies and justify your answer.
( c )
Write an SQL query to list the names of customers who purchased more than three distinct products in the last month (assume the current date is 30 June 2023). Show the query and briefly explain the logic used.
( d )
The database is frequently searched for products by their Category attribute. Explain how creating an index on the Category field of the Product table would affect query performance and discuss any possible trade‑offs.
( e )
A sales transaction involves inserting a new Order record and the related OrderItem records. Discuss how the ACID properties ensure the reliability of this transaction. Mention at least two of the properties in your answer.

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 Neco 2017 Data Processing Question 5. It is one of the essay questions from the 2017 Neco Data Processing examination.

The question covers Relational schema, Primary and foreign keys, Normalization, SQL query formulation, Indexing, ACID properties .

View More Neco 2017 Data Processing Questions More Neco 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