CS 474 - Database Design and Application Spring 2011Weekly Schedule
Schedule subject to change
Links are in blue, reading in green, class assignments in red|
Week
|
General Topic | Monday | Wednesday | Friday | Major deadlines |
| Jan 10 | Introduction DB history DB Environments |
Intro to the class Syllabus |
What is a database? Chap 1.1,1.2,1.3,1.4 |
Database history; Chap 1.5 get to know your teams |
|
| Jan 17 | Modelling |
No class MLK day | Modeling and conceptualizing DBMS- See slides in Blackboard. Chapter 2 |
The relational model - See slides in Blackboard. Chap 4.1, 4.2, see assignment in BB |
|
| Jan 24 | ER Diagramming |
ER Diagrams - See slides in Blackboard. Chap 12 |
ER Diagrams continued Chapter 12, exercise 12.11, pg 347 in UML and Crow's Foot notation |
Finish ERD Chapter 12, exercise 12.12, pg 347 in UML and Crow's Foot notation |
|
| Jan 31 | Relational algebra/calculus Database Lifecycle |
Introduce the projects Chapter 5 Begin Relational algebra. |
Continue relational
algebra, calculus. Quiz Practice exercises |
Meet in Lab 250 ERDiagramming lab. You must be present to receive credit. |
Choose your project (2/4) |
| Feb 7 | Normalization and design | Finish Relational Algebra. | Group meeting time (work on or complete SRS) Meet in 250 Lab |
Normalization Chapter 14 Finish worksheet from Monday |
Individual paper (W) Group SRS(F) |
| Feb 14 | Introduction to SQL and MySQL |
Normalization Chapter 14 |
Finish normalization Exercise 14.15 |
Exam 1 | |
| Feb 21 | Intro to SQL and MySQL |
Review and an introduction to SQL. Chapter 6 |
Day to work on SRS - Final and ERD draft documents in 250 lab |
Meet in 250 lab SQL lab |
Individual SRS eval (M) |
| Feb 28 | MySQL |
Class cancelled due to illness |
Go over exam Introduction to DDL Chapter 7 |
Meet in ISAT/250 SQL DDL lab |
Final group SRS (F) ERD draft (F) |
| Mar 7 | Spring break - enjoy the time off | ||||
| Mar 14 | Design to SQL | Database design exercise |
Time
to work on project. (30.3 and 30.7) |
Design lab continued Final day to submit revised contracts. |
Final ERD and interface |
| Mar 21 | SQL and connections | Design lab continued - Mac lab |
Extended SQL - Oh the possibilities |
Making the connections lab | |
| Mar 28 | Group project status - Intro to DB security | Group project reports | Exam 2 - Coverage, Exam 1 + SQL | Mini project due - Sunday Mar 27; Hardcopy due Monday Mar 28. | |
| Apr 4 | Advanced db topics | Return exams Indexes 7.3 |
Security - Chap 20 beginning, Chap 21 (Overview) Views Procedures, Triggers Chap 7 |
Java front end |
|
| Apr 11 | Alternate DBMS | Triggers, cursors etc Chap 7 |
Transactions Chap 7 Chap 22 |
MySQL/Oracle SQL Server features |
Status report, DDL due |
| Apr 18 | Advanced topics | More security, backup and recovery |
Lab triggers, functions and procedures - See Blackboard |
Other database models Chap 31, 27 |
|
| Apr 25 | Project presentations | Projects | Projects | Projects/Review | Final project deliverables due April 29 no later than 3pm |
| May 6 |
Final Exam - Friday May 6, 8am - in the lab |
||||