This project is a relational database design for a library management system.
The goal of the project is to design and implement a normalized database that supports:
- user registration
- membership tracking
- librarian management
- different membership types
- reporting and SQL analysis
- PowerDesigner
- SQL
- Relational database modeling
- entity relationship modeling
- primary and foreign key constraints
- normalized relational structure
- membership tracking system
- librarian and user management
diagrams/— ER diagrams and database designsql/— SQL scripts and queries
- database normalization
- relational schema design
- entity relationship modeling
- SQL query development
- database constraint implementation
The initial SQL script generated by PowerDesigner required adjustments before it could run correctly in MySQL.
Additional modifications were made to:
- correct syntax issues
- adapt data types
- fix constraint definitions
- improve compatibility with MySQL
The final SQL scripts included in this project reflect these corrections and were successfully implemented.