Library ER Diagram

Added on: Mar 11, 2025
User Prompt

【书籍(Book)】
- 书号(BookID,主键)
- 书名(Title)
- 存放位置(Location)
- 数量(Quantity)
- 出版社名(PublisherName,外键) ────┐

【借阅(Borrowing)】(M:N) │
- 借书日期(BorrowDate) │
- 还书日期(ReturnDate) │

【借书人(Borrower)】 │
- 借书证号(CardID,主键) │
- 姓名(Name) │
- 单位(Unit) │

【出版社(Publisher)】
- 出版社名(PublisherName,主键) ────┘
- 电报编号(TelegramCode)
- 电话(Phone)
- 邮编(ZipCode)
- 地址(Address)