#Normalisation to 3NF for Appendix A
## UNF
Title(**Call_no**, Title, (Author_in_house_code, Author_name), (Subjects), Description, Publisher_in_house_code, Publisher_name, Published_date, Edition, No_pages, Language, Notes, (ISBN) (Branch_code, (Barcode, Status) ))
## 1NF
Title(**Call_no**, Title, **Author_in_house_code**, Author_name, **Subject**, Description, Publisher_in_house_code, Publisher_name, Published_date, Edition, No_pages, Language, Notes, **ISBN** , Branch_code, **Barcode**, Status )
### Partial Dependencies
Call_no $\rightarrow$ Title, Description, Publisher_in_house_code, Publisher_name, Published_date, Edition, No_pages, Language, Notes
Author_in_house_code $\rightarrow$ Author_name
Barcode $\rightarrow$ Branch_code, Status
###Transitive Dependencies
Publisher_in_house_code $\rightarrow$ Publisher_name
## 2NF
Title(**Call_no**, Title, Description, Publisher_in_house_code, Publisher_name, Published_date, Edition, No_pages, Language, Notes )
Author(**Author_in_house_code**, Author_name)
Copy(**Barcode**, Branch_code, Status, Call_no)
Authors(**Call_no**, **Author_in_house_code**)
Subjects(**Call_no**, **Subject**)
ISBNs(**Call_no**, **ISBN**)
## 3NF
Title(**Call_no**, Title, Description, Publisher_in_house_code, Published_date, Edition, No_pages, Language, Notes )
Copy(**Barcode**, Branch_code, Status, Call_no)
Author(**Author_in_house_code**, Author_name)
Authors(**Call_no**, **Author_in_house_code**)
Subjects(**Call_no**, **Subject**)
ISBNs( **ISBN**, Call_no)
Publisher(**Publisher_in_house_code**, Publisher_name)
## Other tables
Branch(**Branch_code**, Branch_name, Address, Phone_no, Manager_ID)
Manager(**Manager_ID**, Name, Phone_no, Home_branch_code)
Borrower(**Borr_ID**, Borr_name, Borr_addr, Borr_class, Borr_HB)
Fine(**Borr_ID**, **Payment_date**, Amount)
Borrow(**Barcode**, **Borr_ID**, **Borr_date, Expct_ret_date)
Reserve(**Barcode**, **Borr_ID**, **Res_date**)
Return(**Barcode**, **Borr_ID**,**Ret_date**)