ASSIGNMENTThe following is a description of a database for university libraries in Ghana. The database would be used to search for books and to keep track of books on loan to users as well as books returned by borrowers.A book is written by one or many authors. An author can write many books. A book is published by a publisher in a given year. A book has a number of properties, one of which is its keyword. In principle there is no limit to the number of keywords that can be used to describe the contents of a book.A library keeps a number of copies of a book. Every book is uniquely identified by an ISBN. The database will contain information on all books kept at the university libraries in Ghana. Every university library is divided into sections. In every university library the sections are uniquely named. The database will also contain information on borrowers such as name, address, the title of the book the borrower has borrowed.The system should also maintain a list of borrowers waiting to borrow a book if all copies of the book have been loaned out.i. Identify the various Entities in the library within any one university in Ghana ii. Using the Entity-Relationship model to construct an Entity Relationship Diagram for the university libraries database indicating the membership functions of the participating entity types in the various relationships, their cardinalities and their key attributes.

English

ScanSolve AI Answer

Here's the breakdown of the university library database design based on your description.


i) Identify the various Entities in the library within any one university in Ghana

Based on the description, the key entities are:

  • BOOK: Represents a unique title, identified by its ISBN.
  • AUTHOR: Represents an individual who writes books.
  • PUBLISHER: Represents a company that publishes books.
  • KEYWORD: Represents a descriptive term associated with books.
  • LIBRARY: Represents a specific university library.
  • SECTION: Represents a division within a library.
  • BORROWER: Represents a user who can borrow books.
Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question