Library+System+Normalisation

The library below has a manual card based system in place whereby all the books that are held in the library are catalogued. Each book is unique but the library can hold many copies of each book.

Catalogue Information




Borrower Details


1.The above data could be written in UNF as follows

__Catalogue number__ Book title Author Publisher name Publisher address Copy number Borrower number Borrower name Date due back

a) State why catalogue number is a suitable primary key (1)

b) Take the system at UNF and convert it 3NF. At each stage indicate all primary and foreign keys (17)

c) Draw and entity relationship diagram for your solution at 3NF (6)