Question :
Suppose you are designing a database for a library, the library system contains information about people who borrow. Each person is uniquely identified. People can search and borrow books. A book has book ID. Author name, book title, subject and publishing year.
The library deals with many publishers. Each publisher has name and is uniquely identified by publisher ID.
Each publisher has many books. When a book is borrowed its status is changed from available Into borrowed and a retrieval date will be determined. Each person can borrow at most five books.
Draw an ERD for the library system.
Identify all fields you plan to include in the tables.