|
CSE-3421M
Introduction to Database Systems
York University
Winter 2013
|
|
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 2013
|
|
Time:
|
Tu & Th 5:30–7:00pm
|
|
Place:
|
HNE #B15
|
|
|
|
|
|
Welcome
to the course
Introduction to Database Systems,
CSE-3421 for winter term 2013.
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.
Marks
accumulating on ePost.
|
|
|
|
|
|
|
|
|
Lecture Notes
- Introduction
- Databases: Asking the Computer Questions.
PDF
- Design
- E-R Modeling
- The Relational Model
- 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
|
|
|
|
|
|
|
|
|
|
|
|