| Lectures | Term Project |
Class Schedule and Notes
| Week | Topic | Class Notes | Class preparation |
|
Sep. 5 |
Course Outline
|
|
Friday:
|
|
Sep. 12 |
|
Tuesday:
Friday:
|
|
|
Sep. 19 |
|
Tuesday:
Friday:
Explain Assignment 1 in the class.
|
|
|
Sep. 26 |
|
Tuesday:
Friday:
DreamHome Entities, Transactions ERD for DreamHome
For Access Tutorials, please refer the Chapter 9 : Query-By-Example.
For ERD Modeling please refer Chapter 12.
|
|
|
Oct. 3 |
|
|
Tuesday:
Assignment 1 Due
Finalize Project Title - Group Members
Friday:
|
|
Oct. 10 |
|
Tuesday:
Friday: |
|
|
Oct. 17 |
Tuesday:
Friday:
|
||
|
Oct. 24 |
|
|
Tuesday:
Guest Lecture Friday: Project Submission - Deliverable 1 (Conceptual Design)
|
|
Oct. 31 |
Tuesday:
Friday:
Project Submission - Deliverable 1 (Logical Design)
|
||
|
Nov. 7 |
Tuesday:
SQL: Data Definition and Manipulation
SQL for Table Definitions and Data Manipulation Friday:
Remembrance Day - No Classes.
|
||
|
Nov. 14 |
Tuesday:
Friday:
|
||
|
Nov. 21 |
|
Tuesday:
Friday:
|
|
|
Nov. 28 |
|
Tuesday: SQL- Case Example
Friday:
Project Submission - Deliverable 2
Project Presentation (All Groups)
|
|
|
|
|
|
|
|
|
|
|
Time Line for INFO 275 (Time block MP/ PM; Tuesday 11.15 - 12.30 & Friday 12.15 – 1.30 P.M.)
|
Week/ Day |
Session |
Topic |
|
|
1. Sep 6 - Tuesday |
1 |
Introduction |
|
|
Sep. 9 - Friday |
2 |
Introduction to Databases |
|
|
2. Sep 13 - Tuesday |
3 |
Introduction to Databases |
|
|
Sep.16- Friday |
4 |
ERD Modeling |
|
|
3. Sep 20- Tuesday |
5 |
|
|
|
Sep. 23 - Friday |
6 |
Database environment (Access – Demo)- Post Assignment 1 |
|
|
4. Sep 27 -Tuesday |
7 |
(Access – Demo) |
|
|
Sep. 30 -Friday |
8 |
Assignment 1 Due ERD Modeling - Example
|
|
|
5. Oct. 4 - Tuesday |
9 |
Finalize Project Title - Group Members Database environment |
|
|
Oct. 7 - Friday |
10 |
Database environment |
|
|
6. Oct. 11- Tuesday |
|
Mid-Term (Quiz 1)
|
|
|
Oct. 14 - Friday |
11 |
Conceptual Design |
|
|
7. Oct. 18 Tuesday |
12 |
Steps |
|
|
Oct. 21 - Friday |
13 |
Local Logical Design |
|
|
8. Oct. 25 - Tuesday |
14 |
Project submission - Deliverable 1 |
|
|
Oct. 28 -Friday |
15 |
Relational Model |
|
| 9. Nov. 1- Tuesday | Normalization | ||
| Nov. 4 -Friday | Normalization (Examples) | ||
|
10. Nov. 8 Tuesday |
16 |
SQL: Data Definition and Manipulation SQL Commands - Branch & Staff
|
|
|
Nov. 11 - Friday |
17 |
Remembrance Day - No Classes.
|
|
|
11. Nov. 15- Tuesday |
18 |
Quiz 2 |
|
|
Nov. 18 - Friday |
19 |
More SQL Commands |
|
|
12. Nov. 22 - Tuesday |
20 |
|
|
|
Nov. 25 - Friday |
21 |
|
|
|
13. Nov. 29 -Tuesday |
22 |
Project |
|
|
Dec. 2 Friday |
23 |
Project submission - Deliverable 2 Final Exam Details
|
|
|
|
|
|
|