Database
293 views
Schema Design
Quick Definition
Defining database table structure and constraints
Full Definition
Defining database table structure, types, relationships, and constraints.
Examples
table design, column types, foreign keys, constraints
Related Terms
data-modeling
normalization
More Database Terms
Trigger
Special procedure that auto-executes on table events
Referential Integrity
Constraint ensuring table relationships remain consistent
Cursor
Database object for traversing result sets row by row
Denormalization
Intentionally adding redundancy to improve reads
Concurrency Control
Managing simultaneous data access while maintaining consistency
SQL
Standard language for managing and querying databases