|
EECS-3421A
Introduction to Database Systems
York University
Fall 2015
|
Class Homepage
|
|
|
Instructor:
|
Parke Godfrey
|
Office:
|
#2050 LAS
|
Office Hours:
|
We 3–5pm
|
& by appointment / availability
|
Ph#:
|
416-736-2100 x66671
|
e-mail:
|
godfrey@yorku.ca
|
|
|
T.A.:
|
To be announced...
|
Office:
|
|
Office Hours:
|
|
e-mail:
|
|
|
|
|
Term:
|
Fall 2015
|
Time:
|
Mo & We 1:00–2:30pm
|
Place:
|
CB 115
|
|
|
|
|
Welcome
to the course
Introduction to Database Systems,
EECS-3421 for fall term 2015.
Materials, instructions, and notices
for the course will accumulate here over the semester.
|
|
|
|
Class
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 will accumulate on
ePost.
-
Project #4,
The Apt App,
is up and running.
(It is essentially like an 11th query from Project #3.)
Due by 11:59pm Monday 7 December 2015.
(Accepted up to a couple of days after without penalty.)
Project #3,
SQL Jeopardy,
is up and running.
Due by 11:59pm Friday 4 December 2015.
Test #2 coming up on Wednesday 18 November!
Due date for Project #2 moved to the 11th.
Test #2 moved to Wednesday 18 November
(from Wednesday 11 November, as in the original schedule).
Project #2,
Voilà: Creating a Database,
is posted.
Due by 11:59pm Wednesday 11 November 2015.
Due by 11:59pm Wednesday 4 November 2015.
Project #1,
Scheming a Schema: The Howling
,
is posted.
Due before class Wednesday 14 October 2015.
Welcome to the class!
|
|
|
|
|
Lecture Notes
- Introduction
- Design
- E-R Modeling
- Chapter 2 textbook slides:
1-per (PDF)
- E-R guidelines & example:
1-per (PDF),
4-per (PDF)
- E-R bookstore example:
1-per (PDF),
4-per (PDF)
- The Relational Model
- Normalization
- Chapter 19 textbook slides:
PDF (1 per),
PDF (6 per)
- Formal definition chart of the normal forms:
PDF
- Queries
- The Relational Algebra & Calculus
- Chapter 4 Textbook Slides / Part A (Relational Algebra):
PDF (1 per),
PDF (6 per)
- Chapter 4 Textbook Slides / Part B (Relational Calculus):
PDF (1 per),
PDF (6 per)
- SQL
- Applications
- Codd's Twelve Commandments:
PDF (1 per)
- Application Programming
- Chapter 6 Textbook Slides (modified):
PDF (1 per),
PDF (2 per),
PDF (6 per)
- JDBC, a practical guide:
PDF (1 per),
PDF (2 per)
- IBM DB2's SQL/PL, a brief example:
PDF (1 per),
PDF (2 per)
- Internet Applications & Multi-tier Systems
- Transaction Management
- System Overview:
PDF (1 per),
PDF (4 per)
- ACID & Transaction Management (for Chapter 16):
PDF (1 per),
PDF (4 per)
|
|
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 DB2 & SQL
|
|
|
|
- Exercises (for study)
- Projects
-
Scheming a Schema: The Howling
Due before class Wednesday 14 October 2015.
-
Voilà: Creating a Database
Due by 11:59pm Wednesday 11 November 2015.
Due by 11:59pm Wednesday 4 November 2015.
-
SQL Jeopardy
Due by 11:59pm Friday 4 December 2015.
-
The Apt App
Due by 11:59pm Monday 7 December 2015.
(Accepted up to a couple of days after without penalty.)
- Tests
- Test #1
- Test #2
- Final Exam (“Test #3”)
|
|
|
|
|