 |
::: Fall 2010 ::: CSC 471, Fall 2010 ::: ::: Instructor: ::: Best viewed with Firefox |
|
| Wk/Date | Topic | Reading | Resources | Remarks / Due / Exam | ||||
| 1 8/23, Mon |
Introduction | Ch. 1 | == self, ch1.ppt == :: database system concepts :: |
|||||
| 2 8/30 |
ER modeling | Sec. 7.1-7.5, 7.7 | == ch7.ppt == | 9/2 Thur, Optional Exercise 1 Due Pg 34: Ex 1.12, 1.13, 1.14 : Project Option B Decision Due |
||||
| 3 9/6 |
Extended E-R | Sec. 7.8-7.9 | 9/6, Mon: Labor Day | |||||
| 4 9/13 |
Relational model, ER to Rel. | Sec. 2.1-2.6, 4.3-4.5 | == ch2.ppt, ch4.ppt == :: W3schools html tutorial :: |
Project Part 1 (ER) Due, Thur | ||||
| 5 9/20 |
Relational Algebra | Sec. 6.1-6.3, 7.6 | == ch6.ppt == :: Apache Software Foundation :: :: PHP.net :: :: MS SQL Database (Express) :: :: MS SQL Remote Conn Blog :: :: MySQL Database :: :: PHPMyAdmin.net (a MySQL GUI) :: |
|||||
| 6 9/27 |
SQL | Sec. 3.1-3.8 | == ch3.ppt == :: W3schools sql tutorial :: :: SQL tutorial (for MS SQL) :: :: SQL tutorial (for MySQL) :: :: W3schools PHP tutorial :: :: PHP Manual :: :: Old Apache, PHP, MySQL notes :: |
Project Part 2 (Rel) Due, Thur | ||||
| 7 10/4 |
Advanced SQL Exam I - 10/7 Thur |
Sec. 3.9, 4.2, 4.6, 5.1 | == ch5.ppt == | 10/8 Fri: Instruction ends for Fall Break 6pm Note: Exam I - 10/7 Thur |
||||
| 8 10/11 |
Advanced SQL | :: Campus SQL Server :: |
10/13, Wed: Classes resume after Fall Break 8am | |||||
| 9 10/18 |
Good DB design and functional dependency | Sec. 8.1-8.3 | == ch8.ppt == | Project Part 3 (SQL) Due, Thur | ||||
| 10 10/25 |
Functional dependency theory | Sec. 8.4 | ||||||
| 11 11/1 |
Decomposition and DB design process | Sec. 8.5-8.6, 8.8 | :: Bulk load help :: | Bonus Quiz - 11/2 Tue |
||||
| 12 11/8 |
Application design and development | Sec. 9.1-9.6 | == ch9.ppt == | Project Part 4 (Load) Due, Tue | ||||
| 13 11/15 |
Triggers and security | Sec. 5.3, 9.7 | ||||||
| 14 11/22 |
11/23, Tue: Instruction ends for Thanksgiving holiday 10pm | |||||||
| 15 11/29 |
XML | Ch. 23.1-23.4 | == ch23.ppt == | 11/29, Mon: Classes resume 8am Project Part 5 (Web) Due, Thur (Max 2 students per group, part 5 only) |
||||
| 16 12/6 |
12/6, Mon: Last Day of Classes | |||||||
| 16, 17 Exam |
Exam II - 12/9 Thur, 12 NOON - 3:00 PM | 12/8-11, 13-14: Final Exams Note: Exam II |
||||||