Exam Questions
| Question | Points | Topic |
|---|---|---|
| q1a-e | 15 | Reading Relational Algebra |
| q2a-e | 15 | Writing Relational Algebra |
| q3 | 15 | E/R Schema Design |
| q4 | 15 | E/R to SQL DDL |
| q5a | 5 | Closure Algorithm |
| q5b | 5 | Keys |
| q5c | 5 | More Keys |
| q5d | 5 | Projecting FDs |
| q5e | 10 | BCNF Decomposition |
| q5f | 2 | Is BCNF Lossless? |
| q5g | 3 | Is BCNF FD-Preserving? |
| q6a | 3 | Is FD Implied |
| q6b | 2 | Minimal Basis |
