Database Design Project: Library Information System Assessment

This project involves a comprehensive database design assessment. Task 1 requires an analysis of an Entity Relationship Diagram (ERD) for a basic library system, identifying entities (publisher, book, author), attributes, primary keys, composite attributes, and relationships (one-to-many and many-to-many) between entities. Task 2 focuses on developing a database for a library information system, detailing the storage of borrower and book records. The database includes attributes such as Borrower_ID, Book_ID, IssueDate, and ReturnDate. The solution provides a data dictionary defining entities like AuthorDetails, BookDetails, BorrowerDetails, and Reservation, along with their respective attributes, types, and keys. The project also outlines user access levels and discusses backup and recovery strategies for the database, including backup schedules and methods for database restoration. The provided bibliography lists the sources used for the project.