Scribd
Upload
2 views1 page

Tutorial Normalization

The tutorial discusses the issues of update and deletion anomalies in an e-commerce platform's single table database and how normalization can address these problems. It also highlights the performance degradation in a banking system due to over-normalization and excessive joins. Additionally, it provides a case study on normalizing an e-commerce order data table to 3NF by identifying partial and transitive dependencies.

Uploaded by

deshani bandara
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

Tutorial Normalization

The tutorial discusses the issues of update and deletion anomalies in an e-commerce platform's single table database and how normalization can address these problems. It also highlights the performance degradation in a banking system due to over-normalization and excessive joins. Additionally, it provides a case study on normalizing an e-commerce order data table to 3NF by identifying partial and transitive dependencies.

Uploaded by

deshani bandara
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Tutorial – Normalization

TICT3123(T)

1. An e-commerce platform stores order, customer, and product details in a single table to
simplify reporting. Over time, update and deletion anomalies are frequently reported.
a. Identify the type of anomalies likely occurring.
b. Explain how normalization can solve these issues.
c. Up to which normal form would you normalize the database and why?
2. A large banking system has normalized its database to BCNF, but query performance
has degraded due to excessive joins. Explain why over-normalization can reduce
performance.
3. An e-commerce system stores order data as: OrderID, CustomerID, CustomerName,
ProductID, ProductName, Price
A customer can place multiple orders, and a product price is fixed.
a. Identify partial and transitive dependencies.
b. Normalize the table to 3NF.
c. Normalize the table to 3NF.

You might also like