|
CSE-3421
Introduction to Database Systems
York University
Winter 2009
|
|
Class Homepage
|
|
|
|
Instructor:
|
Parke Godfrey
|
|
Office:
|
#2050 CSE
|
|
Office Hours:
|
Th 2-4pm
|
|
& by appointment / availability
|
|
Ph#:
|
416-736-2100 x66671
|
|
e-mail:
|
godfrey@cse.yorku.ca
|
|
|
|
|
|
Term:
|
Winter 2009
|
|
Time:
|
Tu & Th 5:30-7:00pm
|
|
Place:
|
CB #115
|
|
|
|
|
|
Welcome
to the course
Introduction to Database Systems,
CSE-3421 for winter term 2009.
Materials, instructions, and notices
for the course will accumulate here over the semester.
|
|
|
|
|
|
|
Course
notices will accumulate here over the term.
Be certain to check here regularly.
Also, be certain to refresh this page via your browser
when you visit to ensure that you are not looking at an old, cached copy.
Otherwise, you can miss the latest message.
Tuesday 19 May 2009 is our last day of lecture.
There are classes on Thursday 21 May 2009;
however that Thursday follows Friday's schedule
(to make up for classes that meet on Fridays).
Our final exam is scheduled for
7-10pm Tuesday 26 May 2009
in SLH #F.
Projects #3 & #4 are up and running.
Both are due by 11:59pm Friday 22 May 2009.
After that is late,
but work submitted before our final exam will be accepted
with no penalty.
|
|
|
|
|
|
|
|
|
Lecture Notes
- Introduction
- Design
- E-R Modeling
- The Relational Model
- Normalization
- Queries
- The Relational Algebra & Calculus
- SQL
- Applications
- Codd's Twelve Commandments:
PDF (1 per)
- Application Programming
- Internet Applications & Multi-tier Systems
- Transaction Management
|
|
|
Resources
- the textbook
- PRISM Accounts
You need a Prism computer account
to do the projects (#2 and onward).
If you do not have one,
do get one set up.
- IBM DB2 & SQL:
- DB2 on PRISM (local notes)
- from IBM
- more on SQL
- materials from Graeme Birchall
|
|
|
|
|
|
|
|
|
|
|
|