Question

Draw an ER diagram for a university library information system which stores

information about books, journals, publishers, students, staff, borrowing of books,

and reservation of books. Note that the library may have more than one copy for

some of the books. You must show the entities, relationships and attributes along

with the cardinality constraints and proper symbols.

Answer 1

ER Diagram is an entity-relationship diagram and it is used to analyze the structure of the Database. It shows relationships between entities and their attributes. An ER Model provides a means of communication.