Physical Data Modeling Physical data modeling is the process of designing tables in a relational database for actual use. It aims to optimize performance through storage space efficiency, data partitioning, and index design. Performance issues can be addressed through slow quer
Kanban Board Project 2 Logical Data Modeling This document explains how to perform logical data modeling based on the conceptual data modeling ERD, step by step, and proposes solutions to difficulties that arise during the normalization process. In particular, it discusses in detail the consideratio
Logical Data Modeling Logical data modeling is the process of transforming a conceptual data model into the relational database paradigm based on mapping rules, handling 1:1, 1:N, and N:M relationships, and ensuring data integrity through normalization. It refines tables throu
Kanban Board Project 1 Conceptual Data Modeling The Kanban Board project was a Wanted Backend internship assignment. I implemented the project again for practice with relational data modeling and conducted conceptual data modeling. Through the process of separating entities, defining identifiers, and i
Conceptual Data Modeling Conceptual data modeling is the process of separating entities, defining attributes, and expressing relationships between entities as ERD. An entity is an independent unit of information, and an attribute is the data that an entity has. An identifier uniq
Relational Data Modeling Relational data modeling is the process of dividing real-world information into tables and data, going through the stages of requirement analysis, conceptual data modeling, logical data modeling, and physical data modeling. Conceptual modeling is visualiz
Mocking Prisma Client for Unit Testing in NestJS Removing external dependencies is essential for application unit testing. You can easily perform unit testing using Prisma ORM's Jest mocking method. By installing the jest-mock-extended package and mocking Prisma Client, you can build a convenient testin