INTRODUCTION$/$OVERVIEW: NORMALIZATION

Process of evaluating and correcting table structures to minimize data redundancies.

INSTRUCTIONS: ONLY ONE$(1)$ MS WORD Document is to be uploaded to Moodle with the solution to the two questions

SCENARIOS$/$QUESTIONS

$1.$ Nestle Jamaica Ltd has a database that tracks sales transactions. The initial design of the database is as follows:

A table named Orders that includes the following columns: OrderID, CustomerName, CustomerAddress, ProductID, ProductName, Quantity, OrderDate and TotalPrice, as shown below:

a$.)$ Identify any redundancy in this table and suggest

b$.)$ how you would normalize up to the second normal form $(2$NF$).$ Explain using Functional Dependencies.

c$.)$ Show the resulting table after $2$ NF