APARTMENT COMPLEX DATABASE
Apartment Complex Database
Goal:
As the final for my Database Design class, I developed a database for a fictional apartment complex. Starting with a 3-schema, I created an ER diagram, identified the functional dependencies and normalized them to 3NF. From there I formed the relational algebra and the SQL functions. Utilizing phpMyAdmin, I created the database and filled it with hundreds of entries of data created by prompting ChatGPT in order to demonstrate my SQL functions.