Neco 2020 Data Processing Question 5

Practice essay / theory question 5 from the 2020 Neco Data Processing examination. This question covers Database Management Systems (DBMS), ER modelling, Relational schema, SQL, Normalization .

Neco 2020 Data Processing Essay / Theory
Topics: Database Management Systems (DBMS) ER modelling Relational schema SQL Normalization
Question 5 NECO • 2020 • DATA_PROCESSING • essay

A small retail store maintains a database to record its sales transactions. The store has three entity types: **Product** (ProductID, Name, UnitPrice), **Customer** (CustomerID, Name, MembershipLevel), and **Sale** (SaleID, Date, CustomerID). Each sale may include multiple products; the quantity of each product sold is recorded in a junction entity **SaleItem** (SaleID, ProductID, Quantity). The attribute MembershipLevel can take the values 'Standard', 'Silver' or 'Gold'. The store offers a discount on the total amount of a sale based on MembershipLevel: Standard – no discount, Silver – 5 % discount, Gold – 10 % discount.

Question Parts

( a )
Draw a complete ER diagram for the described situation. State the entity sets, attributes (including key attributes), relationship sets and the cardinalities of all relationships.
( b )
Convert the ER diagram into a relational schema. For each relation list its attributes and indicate the primary key(s) and any foreign key(s).
( c )
Write an SQL statement that lists the **Name** of every customer who, in the month of March 2023, purchased goods whose total value after applying the appropriate membership discount exceeded ₦10 000.
( d )
Explain two advantages of normalising the above database to at least Third Normal Form (3NF).

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

The question covers Database Management Systems (DBMS), ER modelling, Relational schema, SQL, Normalization .

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