Time Columns
DX, Web, AI
Time Glossary
Database and data-design terms for practical web and business operations.
Database and Data Design
This page organizes terms used in database modeling, tables, records, keys, relationships, ER diagrams, and data structure design.
Entity is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Attribute is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Cardinality is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Normalization is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
A customer master is reference data used to manage customer information.
It can include names, contact details, company names, and transaction conditions.
Sales, inquiries, contracts, and other records often refer to it.
Table is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Field is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Record is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Column is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Primary Key is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Foreign Key is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Relationship is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Dependent Relationship is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Non-dependent Relationship is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Many-to-many Relationship is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Relational Database is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
RDBMS is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
SQL is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Query is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Transaction is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
ER Diagram is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Conceptual Design is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Logical Design is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
Physical Design is a term used in database and data design.
It helps teams discuss the concept with clear shared language.
In practical operations, it should be connected to decisions, implementation, and maintenance.
A hierarchical database manages data in parent-child tree structures.
It is suitable when relationships are clearly organized in levels.
Its design differs from relational databases in flexibility and access patterns.
A network database manages data through graph-like relationships.
A record can have multiple parents or linked relationships.
It can represent complex structures, but design and operation require care.