Database
-
Database NormalizationDatabase 2024. 3. 11. 15:01
데이터베이스 정규화(Normalization)에 대해 정리하였습니다. Database normalization is a process by which database tables are modified/restructured to minimize redundancy When columns of a database table do not depend on (i.e., describe) the primary key, the same data may be duplicated in multiple places. Example : Let’s now examine the college table The primary key of this table is ..
-
Designing Database : Database RelationshipsDatabase 2024. 2. 13. 17:02
관계형 데이터베이스에서 Relationship의 3가지 타입을 정리하였습니다. What are relationships? A database relationship establishes the way in which connected tables are dependent on one another. What are the different types of database relationships? There are three types: one-to-one, one-to-many and many-to-many. : The lines between tables connect foreign keys and primary keys. In a one-to-one relationsh..
-
Designing Database : Database KeysDatabase 2024. 2. 6. 16:40
Database에서 데이터의 효율적인 정의와, 각 테이블간의 관계 설정에 사용되는 Key 키워드 사용에 대해 정리하였습니다. Will learn how to designate certain columns of a database table as keys. What are keys? A database key is a column or group of columns in a table that uniquely identifies a row in a table. Keys enable a database designer to place constraints on the data in a table. We want to enforce d..
-
Designing Database : Database SchemaDatabase 2024. 1. 11. 15:07
데이터베이스를 만들기 전에, 어떻게 개요를 잡을지에 대한 방법을 정리하였습니다. Like an architectural blueprint, a database schema is documentation that helps its audience such as a database designer, administrator and other users interact with a database. It gives an overview of the purpose of the database along with the data that makes up the database, how the data is organized into tables, how the tables are i..
-
Adding a PostgreSQL DatabaseDatabase 2022. 1. 12. 22:59
앱(웹사이트)에 PostgreSQL 데이터베이스를 적용하는 방법을 정리하였습니다. How to interact with a SQL database from within your JavaScript programs using PostgreSQL. Article : How to set up a RESTful API with Node.js and PostgreSQL Node.js, Express.js, and PostgreSQL: CRUD REST API example - LogRocket Blog Knowing how to work with APIs is an important part of modern web development. Lear..
-
database principle of ACIDDatabase 2022. 1. 5. 00:20
데이터베이스의 원칙 ACID에 대해 설명하는 글입니다. Article : ACID Properties in DBMS ACID Properties in DBMS - GeeksforGeeks A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions. www.geeksforgeeks.org Article : 트렌젝션 ACID란? 데이터베이스 트랜젝션 ACID란? ACID(원자성, 일관성, 고립성..
-
Database NormalizationDatabase 2022. 1. 3. 17:16
데이터베이스 정규화(Normalization)에 대해 정리하였습니다. Database normalization is a process by which database tables are modified/restructured to minimize redundancy When columns of a database table do not depend on (i.e., describe) the primary key, the same data may be duplicated in multiple places. Example : Let’s now examine the college table The primary k..
-
Entity Relationship DiagramsDatabase 2022. 1. 3. 10:42
데이터베이스의 설계 모델 중 ERD(개체-관계 모델)에 관한 내용을 정리하였습니다. Article : What is Entity Relationship Diagram (ERD)? What is Entity Relationship Diagram (ERD)? Design Database Faster, Better and Easier Are you looking for a Free ERD tool for creating data models faster, easier and quicker? Visual Paradigm Community Edition provides you with an ERD editor for database design. It is an international award-winning ..