Part A $-$ Task Details $($To be submitted within lab session$)$

Consider the following table, which stores information about a bookstore:

Your task is to normalize this table up to the third normal form $(3$NF$).$ Follow the steps of normalization to create the normalized

tables. Please follow the following syntax when describing the entities:

Entity: $\{$Identifier$\}->$ attribute, attribute, $...($i$.$e$.$: Car: $\{VIN\}->$ year, make, model, trim, colour$)$

Your submission document must clearly provide tables in $3$ NF with primary keys. Use appropriate table names of your choice.

Submission

A Word $($docx$)$ document, complete with your student name and student number at the top of the document, and appropriate titles

for each normalization and appropriate table names. The name of the docx file will be lastname$\_$firstname$\_$lab$5$A$.$docx.

Scoring

The document will be scored as follows:

$5->$ All normal forms are completed, and dependencies resolved.

$3->$ There are some errors in the normalization process.

$1->$ Significant errors are present.

$0->$ not submitted, completely incorrect, etc.