C20.0046 Database Management Systems Spring 2000

What's New!

• Review problems posted.
• Solutions to homework 5 are out.
• Example Access queries can be found here.
• Notice that you can find solutions to the starred exercises in the textbook here. To read postscript files, please download a postscript viewer from here. (the file name is gsv28w32.exe)
• Please send ALL emails related to the project to db-assist@egroups.com - NOT to my email address, so that Costas can keep track of them at the same time.

Index

Resources

For solutions to *'d exercises in the text, go to the solutions pages for the text.

You can download the Northwind database by clicking here.

Introductory Material

1. Course Syllabus (HTML). Note that this is a ``living document''; it will change as new information about the course is known.
2. Course Outline (HTML). Likewise, this outline may change if the schedule requires it.
3. Project information (HTML).
4. Signup sheet (PDF). If you miss the first class lecture, please complete and bring with you in class in the next lecture.

Homeworks

 

Assignment	Topic	Due Date	Answers
Homework 1	ODL and E/R diagrams	Tu 2/8	Solutions 1, Statistics
Homework 2	Dependencies	Tu 2/29	Solutions 2
Homework 3	Relational algebra	Tu 3/7	Solutions 3
Homework 4	SQL	Tu 4/11	Solutions 4
Homework 5	Constraints, and triggers	Th 4/27	Solutions 5

Exams

Lecture Notes

Lecture 1 (pdf)
Lecture 2 (pdf)
Lecture 3 (pdf)
Lecture 4 (pdf)
Lecture 5 (pdf)
Lectures 6-7 (pdf)
Lecture 8 (pdf)
Lecture 9-10 (pdf)
Lecture 11 (pdf)
Lecture 12 (pdf)
Lectures 13-14 (pdf)
Access queries (html)
Lectures 15-16 (pdf)
Lecture 17 (pdf)
Lecture 18 (pdf)
Lecture 19 (pdf)
Lecture 20 (pdf)
Lecture 21 (pdf)
 
 
 

Microsoft Access Resources

1. Access and the Web
2. Microsoft Access tutorials online
3. Microsoft Access 97 Student online companion
4. Microsoft Access Getting started (Microsoft resource)
5. An introductory tutorial created by professor Holowczak at Baruch College.