Database Design2IntroductionAs per the given scenario, the database for a library system needs to be designed. The mainpurpose of this library database will be to save the entire information of student, books,employees, student’s next of kin details etc. A student number is issued to each student when heor she gets registered in the university. There are six sections defined for a library and thatinformation needs to be saved in the database. There is a database for the books catalogue whereall the details about book such as book title, author name, publisher name etc are saved in thedatabase. When a student issue a book, a return date get saved automatically on the basis ofpolicy of library. And when student returns the book to the library after the return date somepenalty amount get saved for each book. This penalty amount is same for each book. Thatbasically depends on the number of days by which after which book is returned to the library.The supplier’s details is also saved in the database from which books are purchased. There is thefacility to reserve the book on first come first serve basis. Students can reserve the book onlinebefore issuing that. Entities1. Student StudentNo, FirstName, LastName, DateOfBirth, Gender, HomeStreet,Homesuburb, Homecity, Homestate, HomePCode, contact_no.2. NextofKin NoKID, FirstName, LastName, DateOfBirth, Gender, HomeStreet,Homesuburb, Homecity, Homestate, HomePCode, StudentNo, Relationship.Foreign key StudentNo references student.3. Section SectionID, Section_name, location, phone_no, no_of_staff