This is the column, or collection of columns, whose values uniquely identify each record or row in a table.
What is the primary key?
100
If any one column in a relation is only partially dependent on the primary key, four categories of these types of problems can occur.
What are update anomalies?
100
The process of analyzing a database design to make sure it is free of potential problems.
What is normalization?
100
This is the association between entities.
What is a relationship?
200
Rows are sometimes called this.
What are tuples or records?
200
The definition for a primary key really defines this key as well.
What is a candidate key?
200
This problem in your table means that you cannot add a row to a table because certain attributes cannot be inserted into the database without the presence of other attributes.
What is an insertion or addition anomaly?
200
Tables that satisfy the definition of a relation except that they include repeating groups.
What are unnormalized relations?
200
This relationship exists between two tables when each row in the first table (primary table) matches more than one row in the second table and each row in the second table (related table) matches only one row in the primary table.
What is a one-to-many relationship?
300
In this type of entity, the order of attributes and records is immaterial and all values in a attribute are values of the same column.
What is a relation?
300
A primary key that consists of two or more fields.
What is a composite primary key?
300
If the same value appears in more than one row (such as an item description) an update could change one row without changing the other row(s) which would create this update problem.
What is an inconsistent data anomaly?
300
When the primary key of a table contains only a single column, the table is automatically in this form.
What is second normal form (2NF)?
300
This type of relationship exists between two tables when each row in the first table matches many rows in the second table and each row in the second table matches many rows in the first table.
What is a many-to-many relationship?
400
In a relational database, each entity has its own one of these.
What is a table or relation?
400
A specific field in a secondary table in which that field's value must match the value of the primary key field of the primary table or must be null.
What is a foreign key?
400
A table has this problem when you delete data from a table and unintentionally lose other critical data as well, so you cannot delete a record correctly.
What is a deletion anomaly?
400
A table is in this form when it does not contain a repeating group.
What is first normal form (1NF)?
400
This rare relationship exists between two tables when each row in each table has at most one matching row in the other table.
What is a one-to-one relationship?
500
A collection of relations is this.
What is a relational database?
500
A column that is not part of the primary key.
What is a nonkey column?
500
Update anomalies occur when there is a column in the table that is a determinant but not a candidate key, which means other columns are not entirely dependent on this important key.
What is a primary key?
500
A table is in third normal form (3NF) when it is in second normal form and the only determinants it contains are these.
What are candidate keys/alternate keys?
500
This table serves as a bridge between two many-to-many tables and has primary keys from each of the two many-to-many tables as its composite primary key.
What is an intersection table, junction table, or a link table?