제이의 블로그

All (7)
Information Technology (7)

Physical Data ModelingPhysical data modeling implements a logical model into actual tables, considering storage space efficiency and performance optimization. Performance can be improved by leveraging slow queries, indexes, and caches.

0
0
April 9, 2024

Kanban Board Project 2 Logical Data ModelingThis document summarizes the logical data modeling practice process for Kanban Board Project 2, where we converted the conceptual data modeling ERD into a table format and performed normalization.

0
0
April 9, 2024

Logical Data ModelingThis article explains the process of logical data modeling, which transforms a conceptual data model into a relational database model. It covers 1:1, 1:N, and N:M relationship handling, as well as normalization (1NF, 2NF, 3NF).

0
0
April 9, 2024

Kanban Board Project 1 Conceptual Data ModelingConceptual data modeling for the Kanban board project was conducted for practice in relational data modeling. It was completed through a process of entity separation, identifier definition, and relationship identification.

0
0
April 9, 2024