Neco 2022 Data Processing Question 5

Practice essay / theory question 5 from the 2022 Neco Data Processing examination. This question covers Database Management Systems .

Neco 2022 Data Processing Essay / Theory

Topic: Database Management Systems

Question 5 NECO • 2022 • DATA_PROCESSING • essay

A small retail store keeps records of its sales, customers and products. The information to be stored is as follows: - Each product has a unique product code (Pcode), a name, a unit price and belongs to a category. - Each customer has a unique customer number (Cno), a name and an address. - Each sale transaction is identified by a unique invoice number (InvNo), the date of sale and the customer who made the purchase. - A sale may contain several line items; each line item records the product sold, the quantity purchased and the line total (quantity × unit price).

Question Parts

( a )

Propose a set of relational tables (including attributes) that will store the above information without redundancy. State the primary key of each table and any foreign keys.

( b )

Using your design, write a relational‑algebra expression that retrieves the names of customers who bought a product from the “Electronics” category in the month of March 2023.

( c )

Identify the normal form of the SaleLine table in your design and justify why it satisfies that normal form.

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

The question covers Database Management Systems .

View More Neco 2022 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