CSC 319 - SummerI 2001
Announcements:
- FINAL:
- Thursday, July 19th @ 6:00pm
- Reminder: The second half of the
class session on Tuesday, 7/17 will be a tutorial. Remember
that the tutorial is optional and is intended for students who would
like extra help preparing for the final exam.
- Reminder: Project #2 is due on Thu, 7/19 (extensions will not
be given). Quiz #3 was the final quiz (i.e. there will
be no quiz on Tue, 7/17).
- Quiz #3 (Tue, 7/10)
will be on SQL. Review Chapter 9, pg 226-230, pg 232-233,
and the lecture notes. Remember to review the additional
material
covered in the lectures,
on Outer Join, String Expressions, and Renaming.
Work problems 9.18, 9.21 (use SQL92 syntax), 9.25 - 9.31 on pg 235
(solutions
are available).
Extra practice
problems and solutions are available.
- Quiz #2 (Tue, 7/3)
will be on SQL. Review Chapter 9, pg 217-225, pg 227-228 (Joining with SQL)
as well as the lecture notes.
Work problems 9.6 - 9.12, 9.14, 9.17, 9.19 on pg 235
(solutions
are available).
- Project #1 has been posted.
- Quiz #1 (Tue, 6/26)
will be on Relational Algebra. Review Chapter 8, pg 203-206
as well as the lecture notes. See
worked problems 1 - 4 on pg 210 and 211 and
work problems 8.20 - 8.26 on pg 214 and 8.28a. - 8.28d. on pg 215
(solutions
are available).
Note: We will have weekly quizzes starting week 2.
The first project will also be handed out
week 2.