[TIL] Junior Web Developer Log - Day 79

TIL

Today, I studied database systems during my commute. Compared with the time when I studied the subject for job interviews, the concepts felt much more challenging this time. In particular, learning normalization in connection with functional dependencies made the material harder to grasp, so I realized that I would need to review it several times in order to understand it thoroughly.

I learned that the main purpose of normalization is to eliminate anomalies in a database. Functional dependency refers to a determining relationship between attributes, while a closure includes all dependencies that can be derived from a given set of functional dependencies. I also reviewed the idea that a canonical cover is a minimized set of functional dependencies with redundancy removed. In addition, I organized the characteristics of major normal forms: Second Normal Form removes partial functional dependencies, Third Normal Form removes transitive functional dependencies, and Boyce-Codd Normal Form requires every determinant to be a superkey.

At work, I also used Playwright MCP to improve both my blog and a company project, and the experience felt revolutionary. What impressed me most was that it did not consume as many tokens as I had expected. Because of that, I believe it will become one of my preferred tools whenever I need to perform important tests.

Since today was Pull Day, I performed pullovers, pull-ups, seated rows, lat pulldowns, and T-bar rows.