translation

This is an AI translated post.

제이의 블로그

Kanban Board Project 1 Conceptual Data Modeling

Select Language

  • English
  • 汉语
  • Español
  • Bahasa Indonesia
  • Português
  • Русский
  • 日本語
  • 한국어
  • Deutsch
  • Français
  • Italiano
  • Türkçe
  • Tiếng Việt
  • ไทย
  • Polski
  • Nederlands
  • हिन्दी
  • Magyar

Summarized by durumis AI

  • Conceptual data modeling was conducted while recreating the Kanban board project.
  • The process of separating entities, defining identifiers, and identifying relationships was performed.
  • Database modeling learning made modeling easier than before.

I decided to recreate the Kanban board project from the backend internship assignment I previously worked on at Wanted, for the purpose of practicing relational data modeling.

I performed conceptual data modeling based on the project requirements.

Modeling Process

  • Separating entities into related data groups
  • Defining identifiers
    • Since there were no candidate keys to use as identifiers, I replaced them all with artificial keys.
  • Identifying relationships
    • Representing cardinality and optionality

Previously, I had difficulty modeling because the concepts were not clearly defined, but after learning about database modeling and proceeding step by step, it was much easier.

Generated Entity Relationship Diagram

Jay
제이의 블로그
1인분이 목표인 초보 개발자
Jay
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

April 9, 2024

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

April 8, 2024

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

April 9, 2024

[Non-Computer Science, Surviving as a Developer] 14. Summary of Frequently Asked Technical Interview Questions for New Developers This is a technical interview preparation guide for new developers. It explains concepts frequently encountered in interviews such as the main memory area, data structures, RDBMS and NoSQL, procedural and object-oriented, overriding and overloading, page
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자

April 3, 2024

[Objects] Chapter 2. Object-Oriented Programming This document explains the object-oriented programming methodology for implementing a movie reservation system, covering concepts such as collaboration, objects, classes, inheritance, polymorphism, abstraction, and composition. It presents methods for sec
제이온
제이온
제이온
제이온

April 28, 2024

[Non-Major, Surviving as a Developer] 13. Technical Interview for Junior Developers This article introduces 7 frequently asked questions in technical interviews for junior developers, along with interview preparation tips. Explore questions and answer strategies for various areas like OOP, databases, networks, and algorithms. Prepare fo
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자

April 1, 2024

[Objects] Chapter 1. Objects, Design In software development, practice is more important than theory, and good design makes code easier to understand and more adaptable to changes. Object oriented design provides a way to properly manage dependencies between collaborating objects, which can
제이온
제이온
제이온
제이온

April 28, 2024

[Non-Major, Surviving as a Developer] 7. Things That Help and Don't Help When Applying for a Job in the Field When preparing for a developer job, a technical blog is not very effective, but GitHub is recommended for project management and source code sharing. Among various certifications, it is good to prepare for the Information Processing Engineer certification
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자
투잡뛰는 개발 노동자

March 29, 2024

Main Character and Sub-Characters The author expresses themselves through various activities such as work, soccer, and sports, and shares their personal values and experiences for each activity. This blog shows various aspects of life through various sub-characters such as 'Alconost Sales
에코훈의 메아리
에코훈의 메아리
에코훈의 메아리
에코훈의 메아리
에코훈의 메아리

March 14, 2024