Task $1-$ Normalisation $1(5$ marks$)$

The table below shows part of a spreadsheet used by libraries to keep track of their stock of books.

Take heed of the following tips and reminders:

There are several valid ways to normalise this data, leading to almost identical solutions.

This scenario only allows for one repeating group, i$.$e$.$ R$1=($Outer Group $\{$Repeating Group$\}).$ Not all groups

of logically related attributes will begin in its own repeating group, i$.$e$.$

A repeating group may contain attributes that will be split into different relations later on$.$

Design a relational database for this scenario by normalising the data to the third normal form, clearly showing the

stages of $0NF,1NF,2NF$ and $3NF.$ State any assumptions you make. Use relational symbolic notation as indicated in

the second lecture, and name the relations upon reaching $3NF.$

Hint: You can$/$should introduce auto$-$incrementing ID columns to serve as the primary key of a relation if a suitable

attribute does not exist in the data. Remember to state assumptions and include them from ONF.

Include a physical E$-$R diagram of your normalised results. Remember to state any assumptions regarding the

cardinality of the relationships in the diagram.