logo

Database Design of Library Management System

   

Added on  2022-08-23

5 Pages436 Words15 Views
Running head: DATABASE DESIGN OF LIBRARY MANAGEMENT SYSTEM
Database Design of Library Management System
Name of the Student
Name of the University
Author’s note:
Database Design of Library Management System_1
DATABASE DESIGN OF LIBRARY MANAGEMENT SYSTEM1
Entity and Attributes:
Entity Name: Books
Attribute Names: bookID, bookTitle, isbn, publisherID, volume, shortDesc,
yearOfPublish, cost, availableCopies.
Entity Name: Publishers
Attribute Names: publisherID, publisherName, address, contact, email, fax,
contactPersonName
Entity Name: Authors
Attribute Names: authorID, authorName, contact, address, email, birthYear, shortDesc
Entity Name: BookAuthors
Attribute Names: authorID, bookID, priority
Entity Name: Students
Attribute Names: studentID, studentName, address, contact, email, class
Entity Name: Borrow
Attribute Names: borrowID, studentID, borrowDate, expectedReturnDate,
numberOfBooks, totalFine
Entity Name: BookBorrow
Attribute Names: borrowID, bookID, condition, actualReturnDate, fine
Entity Name: BookReserve
Database Design of Library Management System_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ISYS224 Database Systems 2017 Assignment
|13
|1356
|305

Library System Analysis: Analyzing the Library System
|15
|1634
|446

Library Management System for Desklib
|42
|1471
|288

Library Management
|1
|348
|128

Library Service System for University | Desklib
|4
|985
|498

The National Violent Death Reporting System
|18
|1069
|27