|
Date
|
Topic
|
Reading
Assignments
|
W e e
k 1
|
|
Mon
|
Syllabus, Why
Databases
|
Chapter 1: pp 1
- 13
|
|
Wed
|
DBMS
Basic SQL
|
Chapter 1: pp 14
– 38,
Chapter 3: pp
113 - 126
|
|
Th
|
Lab Day - Get
familiar with MSAccess and submitting a
lab.
|
Start lab 1
|
|
Fri
|
Keys
|
Chapter 2: pp 53
- 63
|
W e e
k 2
|
|
Mon
|
Functional
Dependencies and
|
Chapter 2: pp 64
- 88
|
|
Wed
|
Normalization
|
Chapter 3: pp
128 - 133
|
|
Th
|
Lab 2 –
Normalization and
|
|
|
Fri
|
Subqueries
|
|
W e e
k 3
|
|
Mon
|
Beginning
Joins
|
Chapter 3:
pp 134 - 140
|
|
Wed
|
Exam 1
|
http://cs.sou.edu/~nordquip/cs360/notes/exam1StudyGuide.html
|
|
Th
|
Lab 3 - Joins
|
|
|
Fri
|
Outer Joins and Unions
|
Chapter 3: pp 141 - 142
|
W e e
k 4
|
|
Mon
|
SQL for table
creation and alteration, data insert, updates, delete
|
Chapter 3: pp 99
– 116
Chapter 3: pp
143 - 147
|
|
Wed
|
Table creation
continued
|
|
|
Th
|
Table creation
continued
|
|
|
Fri
|
Lab 4 - Oracle
|
|
W e e
k 5
|
|
Mon
|
Entity –
Relationship Diagrams
|
Chapter 4:
pp 189 - 198
|
|
Wed
|
Weak/Strong Entities
Subtypes
Recursive relationships
|
Chapter 4:
pp 199 - 217
|
|
Th
|
Exam 2
|
|
|
Fri
|
Lab 5 – ER
modeling
|
|
W e e k 6
|
|
Mon
|
ER ->
Table schemas
|
Chapter 5: pp
231 - 241
|
|
Wed
|
ER ->
Table schemas
|
Chapter 5: pp
241 – 253
|
|
Th
|
Lab 6 –
Reducing an ER model to tables
|
|
|
Fri
|
Concurrency
Control
|
Chapter 6: pp
269 - 285
|
W e e
k 7
|
|
Mon
|
Transactions and Locks
|
Chapter 6: pp
269 - 285
|
|
Wed
|
Transaction
examples
|
|
|
Th
|
Lab 7 -
Transactions
|
|
|
Fri
|
Exam 3
|
|
W e e
k 8
|
|
Mon
|
Consistency
& Isolation
|
Chapter 6: pp
285 - 287
|
|
Wed
|
Accessing DB
from Java application program
|
Chapter 7: pp
325 - 332
|
|
Th
|
No Lab this week
|
|
|
Fri
|
Accessing DB
from the Web using PHP.
|
Chapter 7: 332 –
346. ASP is much like PHP, so the reading
is germane, but syntax is different.
|
W e e
k 9
|
|
Mon
|
Holiday
|
|
|
Wed
|
Putty and Linux
command line / Stored Procedure Intro
|
Chapter 7: p.
329
http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
|
|
Th
|
Putting it all
together
|
|
|
Fri
|
Error Handling
And Triggers
|
Chapter 7:
pp 344-345 for Microsoft tools
|
W e e
k 1 0
|
|
Mon
|
Triggers and XML
|
Chapter 7: pp. 346
- 349
|
|
Wed
|
XML
|
|
|
Thurs
|
Finish labs
|
|
|
Fri
|
Review
|
|