Define the following terms:

Question

1. Partial dependency
2. Transitive dependency
3. Normalization
4. Data anomalies
5. Cardinality

Answer 1

1. Partial dependency – A non-key attribute in a table is dependent on part of the
composite key.
2. Transitive dependency – A non-key attribute is dependent on another non-key
attribute.
3. Normalization – A decomposition process to reduce data dependencies and data anomalies.
4. Data anomalies – A deletion anomaly that deletes information about one entity
while deleting information about another entity. An insertion anomaly that does
not allow insertion of an entity unless information about another entity is known.
5. Cardinality – The lower and upper limit information about a relationship.