|
CSE-3421M
Introduction to Database Systems
York University
Winter 2011
|
Class Homepage
|
|
|
Instructor:
|
Parke Godfrey
|
Office:
|
#2050 CSE
|
Office Hours:
|
We 3-5pm
|
& by appointment / availability
|
Ph#:
|
416-736-2100 x66671
|
e-mail:
|
godfrey@cse.yorku.ca
|
|
|
|
|
Term:
|
Winter 2011
|
Time:
|
Tu & Th 5:30-7:00pm
|
Place:
|
Ross South #203
|
|
|
|
|
Welcome
to the course
Introduction to Database Systems,
CSE-3421 for winter term 2011.
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.
|
|
|
|
|
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
- 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
|
|
|
|
|
|
|
|