Project Title: "University of Texas Football Stats Database"
What I set out to do:
I wanted to create a database with a structure at least in Second Normal Form. To do this, I needed to create an ERD to visualize the structure. There also needed to be an admin or user login in order for that person to be able to create, read, update, and delete from the database tables. Another thing I set out to add was a search function in order to retrieve the associated records.
Visit the page
What I learned:
The importance of database normalization, the process of organizing data in a database efficiently by reducing redundancy and dependency by organizing fields and table of a database. Second Normal Form (2NF), ensures that all non-key attributes are fully functionally dependent on the entire primary key. This process helps optimize database design for data integrity, efficiency, and maintainability.