Transaction
·
Computer Science/Database
A transaction in a database refers to a unit of work that performs a single logical function,which is a group of multiple queries bundled together.In databases, a transaction is a series of operations or queries that form a single logical unit of work.These operations ensure the database remains consistent by following the ACID properties:AtomicityConsistencyIsolationDurabilityAtomicity (원자성)Ato..
ERD
·
Computer Science/Database
ERD (Entity Relationship Diagram)An ERD serves as the fundamental blueprint when building a database,defining the relationships between relations (tables).ERDs are created based on system requirements, and the database is built from this design.Even after the database is built, ERDs can serve as a reference for debugging or redesigning business processes.However, while ERDs are useful for repres..
Elements that make up the database
·
Computer Science/Database
EntityAn entity is a noun that has multiple attributes, such as a person, place, object, event, or concept.Relation_릴레이션A relation is the basic unit for storing data in a database,where data about an entity is managed within a single relation.In relational databases, a relation corresponds to a table — tables are made up of records (rows), and tables together form a database.In NoSQL databases, ..