DATABASE
MANAGEMENT SYSTEMS (CSE530)C. DAVID BUTLER, PHARM.D., M.B.A.
AFFILIATE ASSISTANT PROFESSOR
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
WASHINGTON UNIVERSITY IN ST. LOUIS
CLASS: 4:00-5:30PM MW | LOCATION: LOPATA HALL, ROOM 103 | OFFICE HOURS: MW 2:00-4:00PM | PHONE - OFFICE: 314.935.9824;CELL: 314.369.2988 | Teaching Assistants | Graders email account
| Week |
Monday |
Wednesday |
Comments |
|---|---|---|---|
| 1 | August 30 | September 1 | Chapter 1 | Lab 1 - Submit a description of the schema required to import the Phonebook files and the number or rows in each table - Due via email - Sept 8, 11:59PM. |
| No class | Introduction and History of DBMS | ||
| 2 | September 6 | September 8 | Chapter 2 | Import the project data file and submit a count of the total number of rows and a count of the total number of distinct rows - Due via email - Sept 15, 11:59PM. |
| No class Labor Day |
Database environments,
Data models Domains, datatypes and tuples |
||
| 3 | September 13 | September 15 | Chapter 3 | |
| The relational model | The relational model | ||
| 4 | September 20 | September 22 | Chapters 4 and 5 | Submit relational algebra answers by Sept 27, 11:59PM. One possible grading key. |
| Relational algebra | Relational algebra; SQL: DDL | ||
| 5 | September 27 | September 29 | Chapter 5 | Submit ALTER TABLE statement by October 4, 11:59PM. |
| SQL: DML | SQL: DML | ||
| 6 | October 4 | October 6 | Chapter 6 | |
| Exam I (Covering weeks 1-5) |
SQL: DML | ||
| 7 | October 11 | October 13 | Chapters 4, 7 and 11 | Submit QBE Conversion answers to grader's account by October 20, 11:59PM | Submit SQL lab to grader's account by October 25, 11:59PM. |
| Relational calculus QBE |
ER Modeling | ||
| 8 | October 18 | October 20 | Chapter 13 | |
| Functional Dependencies | Normalization | ||
| 9 | October 25 | October 27 | Chapter 13, Appendix C | |
| Normalization - Advanced Normalization | Advanced NF - Physical Storage | ||
| 10 | November 1 | November 3 | Chapters 9, 10 and 15 | B+ Trees due November 10 | SQL Queries Part 2 due November 15 |
| Exam II (Covering weeks 6-BCNF) |
Physical Storage | ||
| 11 | November 8 | November 10 | Chapter 16, 17 and 19 | Topic Presentation Evaluation Forms |
| Physical Storage, Design Methodology | Topic Presentation: Security |
||
| 12 | November 15 | November 17 | Chapters 20, 18 and 21 | SQL Server Example |
| Topic Presentation: Transaction Management |
Topic Presentation: Query Processing |
||
| 13 | November 22 | November 24 | Chapters 25-27 | |
| Topic Presentation: OODB |
No class Thanksgiving break |
||
| 14 | November 29 | December 1 | Chapters 22-24 | SQLEmbedded - Lab due December 6 at 11:59PM |
| Topic Presentation: Distributed Databases |
Topic Presentation: Replication/Mobility |
||
| 15 | December 6 | December 8 | Chapters 31-33 | OLAP Info |
| Topic Presentation: Data Mining |
Topic Presentation: Data Warehousing |
||
| 16 | December 13 | December 15 | Chapter 34 | Projects due December 15 |
| No Class | No Class | ||
| 17 | December 20 | ||
| Final Exam 4-6:00 PM (Covering weeks 1-16) |