I've attached a picture and I'm wondering if it's correct or not for this assignment. If not, How can I fix it ?

Thank you

ADDITIONAL LINK FOR PHOTO: https://s14.postimg.org/iw4iwikpd/321.jpg

Assume that you have been given the task of creating a system for a library to keep track of their books, the borrowers of the books, and the books that are currently lent out. Your first step will be to create the relations necessary for this system.

Book will need information such as a unique identifier for each book, title, author, ISDN number, date of publication, cost.

Borrower will need information such as a unique identifier for the person such as a library card number, name, address, phone number, date of membership

BooksLended will need information such as the book checked out, the date the book was checkedout, when it must be returned, the borrower of the book, etc.

Librarian will need information on the librarians who can perform the check out of a book. This will include a way to identify each librarian, their name, and extension phone number.

Be sure to identify what are candidate, primary, alternate keys and the degree of each relation. It would be recommended that you document your relations in the manner used in the Sharma et al.text.

Assignment Grading Rubric

Assignment documents the relations required for the library system and includes each of thefollowing:

o Book

o Borrower

o BookLended

o Librarian

Each relation must define an identifier and its data types that uniquely identifies each tuple

The degree of each relation must be described

Each relation must include appropriate information other than identifiers such as attributes and the data type of attributes

o The book relation includes at least title, author, ISDN number, date of publication, and cost along with the data types that are appropriate to the data

o The borrower relation includes at least library card #, name, address, postal code, phone number, and date of membership along with the data types that are appropriate to the data

o The booklended relation includes at least borrower, check out date, return date, book id, librarian

o The librarian relation includes at least librarian id, name, phone number

ADDITIONAL LINK FOR PHOTO: https://s14.postimg.org/iw4iwikpd/321.jpg

Copy Check Cell inked Cell Not: 0 PRODUCT NOTICE Ecehan't ben activated Tak..pus ng F r.wihauimernpr:cn.etun. before Mandy, February 12, 201 Activ to 2 LIBRARIAN entity No.Entity set Relationship Type Relationship set Book BORROW 1 LIBRARIAN Strone 2 BOOK MONEY LICRARINN ID 5 NAME LibrarianBook Book- Book Lended STATUS BORROWER Strong 4 BOOK LENDED Strong 13 B0OK entity Rekuonstis degre 6 BOOK LENDED entity pdesree S LIDEARIA ID TATUS Composite saribu Denved aticute Derived attricute Darnived atwrioute 19 DATE,OF FUELICAT0v s BORROWER entity Relzdonstis degree 10 Composioesibu POSTAL 0ODE O lype hene to search RIF