 |
|
CIS 407 Database Design &
Implementation
11:00 AM - 12:15 PM | Parker
Visit the Course Website
|
|
The class notes are in a
password-protected directory.
username:
parkerdir (if no domain is requested, the username is cobweb\parkerdir)
domain:
cobweb
password:
nothard
|
|
| |
Date |
Title |
|
|
|
Tue, 01/10 |
Introduction |
|
|
|
Thu, 01/12 |
Entity-Relationship
Model |
Ch. 4 |
|
|
Tue, 01/17 |
Entity-Relationship Model (exercise)
(answer) |
Ch. 4 |
|
|
Thu, 01/19 |
Entity-Relationship Model II |
Ch. 4 |
|
|
Tue, 01/24 |
Entity-Relationship Model exercises |
Ch. 4 |
|
|
Thu, 01/26 |
Normalization |
Ch. 5 |
|
|
Tue, 01/31 |
Normalization
Project Introduction |
Ch. 5 |
|
|
Thu, 02/02 |
Normalization examples (exercise) (answer) |
|
|
|
Tue, 02/07 |
Data Model Validation
(paper)
Access
Validation |
|
|
|
Thu, 02/09 |
Creating
and Manipulating a SQL Server Database |
|
|
|
Tue, 02/14 |
SQL |
Ch. 6 |
|
|
Thu, 02/16 |
SQL
(SQL Reference from
ZDNet -- Part I)
Word
version |
Ch. 6 |
|
|
Tue, 02/21 |
Nice Overview
Exercise – SQL Server
(creation/manipulation/administration) |
|
|
|
Thu, 02/23 |
DB Administration |
Ch. 6 |
|
|
Tue, 02/28 |
Advanced SQL |
Ch. 6 & 7 |
|
|
Thu, 03/02 |
Advanced SQL |
|
|
|
Tue, 03/07 |
Transact-SQL
Exercise – SQL Queries |
|
|
|
Thu, 03/09 |
Advanced SQL
(SQL Reference from
ZDNet--Part II)
Word version |
|
|
|
Tue, 03/14 |
.........................................................SPRING
BREAK...................................................... |
|
|
|
Thu, 03/16 |
.........................................................SPRING
BREAK...................................................... |
|
|
|
Tue, 03/21 |
Transactions
Review |
Ch. 6 & 7 |
|
|
Thu, 03/23 |
Exam |
|
|
|
Tue, 03/28 |
VB Applications
VB Applications (Detailed explanation) Demo 1
VB Applications (VB Controls) Demo 2 |
|
|
|
Thu, 03/30 |
ASP Web Applications
ASP Demo
VB vs
ASP |
|
|
|
Tue, 04/04 |
Transactions and Concurrency |
|
|
|
Thu, 04/06 |
Transactions and Concurrency |
|
|
|
Tue, 04/11 |
Stored Procedures (chapter)
Stored
Procedures Exercise |
|
|
|
Thu, 04/13 |
Exercise – Transactions and Stored Procedures |
|
|
|
Tue, 04/18 |
Views Exercise |
|
|
|
Thu, 04/20 |
Triggers |
|
|
|
Tue, 04/25 |
Embedded SQL vs Stored Procedures
Advanced Triggers
Exercise – Triggers |
|
|
|
Thu, 04/27 |
Distributed Database Systems |
|
|
|
Tue, 05/02 |
Distributed Database Systems |
|
|
|
Thu, 05/04 |
SQL
Injection Attacks
Review |
|
|
|
Thu, 05/11 |
Final
Exam: 10:00 AM - 12:00 PM |
|
|
