Homework 1 – You must study the following sections of the textbook
(DB System Concepts):
From Chapter 1. Sections: 1.1, 1.2, 1.3, 1.4, 1.5, 1.11
From Chapter 2. Sections 2.1, 2.2, 2.3
From
Chapter 5: Section 5.2 (Domain Relational Calculus)
Do the
following exercises (due on Monday October 5):
-
Exercises 2.1, 2.4, 2.5,
and 2.10
from the textbook
-
Express queries Q9,
Q11, and Q12 in both relational algebra and domain relational calculus.
(You can find these queries in http://www.cs.ucla.edu/classes/fall09/cs143/notes/queries.htm)
Homework 2 -
Due Monday October 12 -
Do Exercises 3.1, 3.9, and 3.10, from the textbook.
Study Ch 3 all, and Ch 4 till
4.3 (excluded)
Homework 3 – Due on Monday
October 26:
Study chapters
11.1, 11.2, 11.3, 11.5,
11.6, 11.77. Also study Chapters 12.1-3,
12.6-8, 12.10
Do Exercise 4.4. Also do Exercise 5.12 in QBE only (ignore the Datalog part)
Also
Do Exercises 12.3,
12.4, 12.15, 13.3a, 13.3b, 13.10.
Homework 4– Study Sections
6.1-6.9 and 7.1-7.3 of textbook.
Also
study Sections 7.4 and 7.5. Also
section 6.9.
Finally
study Section 15, 15.2.2. excluded.
Do
exercises 6.15, 6.16 and 7.1, 7.2, 7.3, 7.25, and 7.30.
Also
do Exercise 15.10 and 15.12.
Homework 5– From the textbook:
Study Sections 6.1 (excluding
6.1.4 and 6.1.5).
Also, study the complete sections 16.2
and 16.6.
Then
study Sections 17.1, 17.2, 17.3 and 17.4.
Finally study Chapter 22 till section 22.4 included.