Keys
Values in a column or set of columns that can be used to uniquely identify a row.
What is a Primary Key?
What is denormalization?
This relation is shown with three small lines, often referred to as crows feet.
What is a one-to-many relation?
This table element holds the same type of data for each cell.
What is a column?
A generated unique value with no real-world meaning.
What is a Surrogate Key?
A form of a table with the feature that every non-primary-key column is functionally dependent on the entire primary key but not functionally dependent on any proper subset of the primary key.
What is Second Normal Form?
When making many-to-many relationships in a database, this must be created.
What is a bridge table?
An academic term for a table row.
What is a tuple?
One executes commands, provides security, enables network access, and provides admin tools, the other stores data.
What is a DBMS and a database?