Modern web apps rely on solid data management. This project was my deep dive into the classic LAMP-style architecture for business tools.
Relational Database Normalization
I focused on creating a 3NF normalized MySQL database for a library system. This ensures referential integrity and optimizes query performance for searching thousands of student and book records.
Implementing Enterprise Security Standards
Security is non-negotiable. I utilized PHP Data Objects (PDO) with prepared statements to mitigate SQL injection risks, alongside hashing for secure user authentication.
Technologies Analyzed
PHP MySQL Database Security