Exam I Syllabus
Exam I will cover all the material covered until 13th Feb. If you have questions, bring them to class on 17th, and I'll try to answer them.
Practice Questions
Here are some practice questions from the course book. Here are the solutions.
Chapter 2 (relational algebra)
- Q2.4.1 e), f), h).
- Q2.4.5
- Q2.4.7
Chapter 3 (functional dependencies & decompositions)
- Q3.1.3 a) and c)
- Q3.2.2 ii)
- Q3.2.4 b)
- Q3.2.10 b)
- Q3.3.1 e)
- Q3.4.1 b)
- Q3.4.2 b)
- Q3.5.2
- Q3.6.3 c)
- Q3.7.1 b)
- Q3.7.4 b)
Chapter 4 (ER modeling)
Chapter 6 (SQL)
- Q6.1.2 c)
- Q6.1.5
- Q6.2.1 d), e)
- Q6.3.3
- Q6.3.5 a)
- Q6.4.6 d), j)
- Q6.4.8