Elements that make up the database

Entity

An 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, a relation corresponds to a collection.

 

---

Attribute

An attribute is a specific, uniquely named piece of information managed within a relation.

---

Domain

The domain is the set of possible values that each attribute in a relation can take.

 

---

Fields and Records

 

For example, the entity Member might be represented as:

• A table named member
• Attributes like name, ID, and address represented as fields_필드
• Each row (record_레코드 or tuple) in the table represents a single member’s data