Ive come up with a SQL database for Library after viewing several already online

Question

Ive come up with a SQL database for Library after viewing several already online.

Ive attached the logic design and its corresponding UML digaram. Is the UML diagram correct? Also is the logic design correct?

If not please point out the corrections with answers.

Library (Library ID, BuildingName, Contact) PK Library ID Staff (Staff ID, Staff name, Designation) PK Staff ID Student (Student ID, Studen name, DOB, Borrow ID, Department, Contact) PK (Student ID) FK w ID references Borrower (ID) Book (ISBN, Title, Author, Edition, Library ID, Publisher ID, Year, Category ID, CurrentCopies, ActualCopies) PK (ISBN) FK Publisher ID references Publisher (Publisher ID) FK Category ID references Category (Category ID) FK Library ID references Library (Library ID) Borrows (Borrow ID, book ID, borrowed From, borrowed Till, actual return, issued by, Student ID) PK (Borrow ID, book ID, borrowd From, ssued by, Student ID) FK book ID references Book (ISBN) FK issued by references Staff (Staff ID) FK Student ID references Student (Student ID Publisher (Publisher ID, Name) PK Publisher ID Category (Category ID, Name) PK Category ID

Explanation / Answer

The UML diagram for online library is absolutely correct and the logic design is also absolutely fine.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.