1. Explain why database re-engineering and redesign is necessary.
2. What is the difference between a correlated subquery and a regular subquery?
3. Explain what is done when a NOT NULL column is added to a table.
4. What is a dependency graph?
5. Explain what should be done when adding tables and relationships for normalization.