Database$\_$Normalization$\_$Practice$\_...$

$1$ of $3$

Database Normalization Practice Assignment

Objective:

To understand and apply the concepts of database normalization in SQL Server. This exercise involves designing a database, identifying anomalies, and normalizing it up to the third normal form $(3$NF$).$

Background:

You are given a scenario where a bookstore wants to manage its inventory and sales records in a database. The initial design of the database is in an unnormalized form $($UNF$).$

Scenario:

A bookstore maintains a single table called 'BookSales' with the following columns:

'SaleID' $($unique identifier for each sale$)$

'BookTitle'

'Author'

'Category' $($e$.$g$.,$ Fiction, Non$-$fiction, Educational$)$

'PublishDate'

'CustomerID'

'CustomerName'

'SaleDate'

'QuantitySold'

'PricePerUnit'

Tasks: