(1) Books are uniquely identified by the Book_id. Users can query the book name, quantity, and its stored location. (2) Before borrowing the book, the library staff will read the borrower information, which includes borrower_id, borrower_name and department. (3) Each book is published by a publisher. A publisher can publish several books. The publisher information includes publisher name, publisher telephone, and publisher address. (4) Each user can borrow several different books, each book can be borrowed by several users. The action of borrow has the attributes of borrowing date and returning date. According to the descriptions above, please finish the following questions: Design the Entity-Relationship diagram. 2. Change the ER model into the relational model. Also identify the primary and foreign key in schemas.
In a library management system, the data management requirements are described as follows:
(1) Books are uniquely identified by the Book_id. Users can query the book name, quantity, and its stored location.
(2) Before borrowing the book, the library staff will read the borrower information, which includes borrower_id, borrower_name and department.
(3) Each book is published by a publisher. A publisher can publish several books. The publisher information includes publisher name, publisher telephone, and publisher address.
(4) Each user can borrow several different books, each book can be borrowed by several users. The action of borrow has the attributes of borrowing date and returning date.
According to the descriptions above, please finish the following questions:
- Design the Entity-Relationship diagram.
2. Change the ER model into the relational model. Also identify the primary and foreign key in schemas.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
