|
CMSC 461 Database Management Systems |
|
Schedule |
|
Following are the reading assignments, homework problems, project dates, and exam dates. Keep in mind that this schedule may change.
Homework problems are listed for each section. Homework will not be graded, but may be reviewed with the TA during office hours. Solutions to many homework problems are also listed on the web site for the text book.
Assigned Readings and Homework Problems · Introduction (Chapter 1) - 1/31 o Homework 1.1, 1.2, 1.3, 1.4 o Project 1 - 2/6 Database Concepts o Relational Model (Chapter 2) - 2/2 o Homework 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8 o Project 2 - 2/8 Relational Model o SQL – Intro (Chapter 3) - 2/7, 2/9, 2/14, 2/16 o Homework 3.1, 3.2, 3.3., 3.4, 3.5, 3.6, 3.11, 3.12 o SQL – Intermediate (Chapter 4 ) - 2/21, 2/23 o Homework 4.1, 4.2, 4.3, 4.4, 4.5, 4.6 o Project 3 – 2/27 SQL Expressions o E-R Model (Chapter 7) - 2/28, 3/2, 3/7 o Homework 7.1, 7.2, 7.3, 7.4, 7.5, .7.6, 7.7, 7.8 o Database App Programming - (Chapter 5.1, 9.1-9.4) - 3/9 o Homework 5.1, 5.2, 5.3, 5.4, 5.5, 5.6, 5.7, 5.8 o Project 5 - 3/27 Java / JDBC /Oracle Application o Relational Database Design (Chapter 8.1-8.5) - 3/14, 3/16, 3/28, 3/30 o Homework 8.1, 8.2, 8.3, 8.4, 8.5, 8.6, 8.7, 8.8, 8.9, 8.11, 8.12, 8.13
o Midterm Exam – 4/4
o Storage and File Structure (Chapter 10) – 4/6, 4/11 o Homework 10.1, 10.2, 10.3, 10.4, 10.5 o Project 6 - 4/17 Database Design o Advanced Database App Programming (Chap 5.2, 5.3) - 4/11 o Homework 5.4, 5.5, 5.6, 5.7, 5.8 o Transactions (Chapter 14) - 4/13 o Homework 14.1, 14.2, 153, 154, 14.5, 14.6, 14.7 o Indexing and Hashing (Chapter 11) - 4/20, 4/25 o Homework 11.1, 11.2, 11.3, 11.4, 11.5, 11.6, 11.7, 11.8 o Query Processing (Chapter 12) - 4/27, 5/2 o Homework 12.1, 12.2, 12.3 o Project 7 - 5/1 Database Application o XML (Chapter 23) – 5/2, 5/9 o Review — 5/11
o Final Exam - as scheduled (currently MON, MAY 16 3:30-5:30 PM) |
