Ask a question to Desklib · AI bot
Database Design.
Added on -2019-09-22
| 8 pages
| 456 words
| 371 views
Trusted by 2+ million users,
1000+ happy students everyday
Database Design15915 Database DesignCOLT2, 2017Fahad AlSuwaidiU3161044Professor NameDate
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
Database Design34. Staff StaffNo, Fname, Lname, position, DateOfBirth, Gender, contact_no, office_no,SectionIDForeign key SectionID references section.5. Supplier SupplierID, Supplier_name, Supplier_address, supplier_city, supplier_phone.6. Catalogue CatalogueNo, book_title, author_name, publisher_name, publisher_Address,book_type, SupplierID.Foreign key SupplierID references supplier.7. Book_issued StudentNo, CatalogueNo, Return_date, late_charge, StaffNoForeign key StudentNo references student, CatalogueNo references catalogue, StaffNoreferences Staff8. Book_reserved ReservedId, CatalogueNo, StudentNo, book_title. Foreign key StudentNo references student, CatalogueNo references catalogue9. Payment ReceiptNo, StudentNo, Amount, dateForeign key StudentNo references student.Entity Relationship Diagram
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan