程序代写代做代考 #Normalisation to 3NF for Appendix A

#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**)