Assignements for CS240A, Winter 98
(Weekly assignements are listed in reverse temporal order)
Assignement for weeks 9,10
Student presentations were delivered in
these two weeks. Also, the
GEM Paper was distributed and Project 3 was assigned.
Assignement for week 8
Midterm, and correction. Also, Project 2 was assigned.
Assignement for week 7
Study notes on SQL3 and OR systems. Refer to
DMS, Chapter 21 and
FCDB, Chapter 8 for further information.
Assignement for week 6
-
Homework on active DBs
-
Study Sections 2.5 in ADS.
Study Sections 3.1, 3.2, 3.3, and 3.4 in ADS.
Study Sections 4.1, 4.2, 4.4, and 4.5 in ADS.
Assignement for week 5
-
Study Sections 2.1, 2.2, and 2.3 in ADS.
Also read Chapter 6 in "A First Course in Database Systems."
- Project 1--Part 2
Assignement for week 4
-
Study Chapter 6 in ADS.
- Project 1--Part 1
Assignement for week 3
Study:
-
Notes on
Calendars and Time,
- time in SQL2 [handout],
and time in Oracle [see ... cs240a/oracle/aut97/widjaja-time.txt]
- Chapter 5 in ADS.
Express the (temporal projection)
query "What is Bob's salary history?"
in:
-
recursive SQL
-
stratified Datalog (thus you cannot use the solution
in Example 10.12 of ADS)
- Re-express the solution of Example 5.5 in Datalog.
Assignement for week 2
Study Sections 9.1--9.5 from ADS.
Do Exercises 9.1--9.5. (Even when the
book says "Prolog" you will write Datalog
programs)
Assignement for week 1:
Study Chapter 8 of ADS.
Do Exercises 8.1--8.7 and 8.12--8.16 of ADS
General Work Plan
-
There will be short weekly assignements,
and several (probably 3)
large projects
-
All assignements must be turned in at the end of
the class. They will contribute to the score of the take-home
final.
-
I will post solutions for some of the assignements, but not all.
In paricular, I will leave out those that you should
find easy to do--if you find those difficult
consider dropping the class.
Carlo Zaniolo
January, 12 1997