Database Constraints and Normalization
Database Constraints and Normalization
Integrity Constraints and Domain Constraints
- Integrity constraints ensure that changes made to the database by authorized users do not l...}
Database Constraints and Normalization
Assertions and Triggering
- An assertion is a statement in SQL that ensures a certain condition will always exist in th...}
Database Constraints and Normalization
Functional Dependencies (Chase Algorithm)
- Formal definition of functional dependency is: Attribute B is functionally dependent upon a...}
Database Constraints and Normalization
Multi-valued and Joined Dependencies
- In contrast to the functional dependency, the multi-valued dependency requires that certain...}
Database Constraints and Normalization
Different Normal Forms (1st, 2nd, 3rd, BCNF, DKNF)
- A relation is said to be Unnormalised when it has not had any normalization rules applied t...}