Database Exercises
Library database
Task: Database Design for a Library Management System
Step1
Step2
After Normalization
Final ER Diagram
Books
book_id
Postal Codes
postal_code
Members
member_id
postal_code (FK)
Borrowed
borrow_id
book_id (FK)
member_id (FK)
Ratings
rating_id
book_id (FK)
member_id (FK)
Events
event_id
member_id (FK)
Late Fees
fee_id
member_id (FK)