Comprehensive Database Design and Implementation for MyLibrary Website

This assignment presents a comprehensive database design and implementation for a MyLibrary website, detailing the structure and functionality of the system. It begins by outlining the various content pages required for the website, including pages for admin login, user login, adding and updating members, managing books and CDs/DVDs, and displaying item details. The solution then delves into database normalization, explaining the principles of 1st, 2nd, and 3rd normal forms and applying these concepts to the MyLibrary database tables, ensuring data integrity and minimizing redundancy. The assignment includes an Entity-Relationship Diagram (ERD) to visually represent the database schema, along with detailed data dictionaries for each table, specifying attributes and their characteristics. Furthermore, the solution provides the database generation code, including SQL scripts to create the tables and populate them with sample data. Finally, the assignment includes documentation of the developed system, featuring screenshots of various pages and functionalities, such as the home page, login pages, add book/CDs pages, update pages, and member views, along with a user manual that explains how to navigate and use the website's features, including admin and member functionalities. The assignment demonstrates a solid understanding of database design principles, normalization, and practical implementation of a web-based library system.