요약
No response
카테고리
No response
파일 슬러그
log-79
저장 폴더
No response
태그
work, work-out, cs
작성일
No response
수정일
No response
본문
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.
요약
No response
카테고리
No response
파일 슬러그
log-79
저장 폴더
No response
태그
work, work-out, cs
작성일
No response
수정일
No response
본문
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.