Information Systems and Database Design
|
| Date | Week | Subject | Reading pages | Pages | Homework | Date Due |
|---|---|---|---|---|---|---|
| August | ||||||
| 27 | 1 | Overview of class, Introduction to DBMS | 6-21, 25-30 | 20 | 1 | September 10 |
| September | ||||||
| 1 | 2 | No Class | ||||
| 3 | 2 | The database environment | Chapter 2 | 35 | 2 | September 10 |
| 8 | 3 | The relational model | Chapter 3 | 19 | 3 | September 15 |
| 10 | 3 | The relational model | " | 13 | ||
| 15 | 4 | Relational algebra | Section 4.1 | 15 | 4 | September 22 |
| 17 | 4 | SQL Overview, SELECT, FROM, WHERE, ORDER BY | 110-127 | 18 | 5 | September 29 |
| 22 | 5 | Aggregates, GROUP BY | 127-132 | 5 | ||
| 24 | 5 | Nesting, Combining | 132-148 | 16 | ||
| 29 | 6 | INSERT, DELETE, UPDATE | 148-153 | 5 | ||
| October | ||||||
| 1 | 6 | Data Definition Language | Chapter 6 | 40 | ||
| 6 | 7 | Exam 1 | 6 | October 15 | ||
| 8 | 7 | DDL, Relational Calculus, QBE | Section 4.2, Chapter 7 | 35 | ||
| 13 | 8 | Database Planning | Chapter 9 | 33 | ||
| 15 | 8 | Requirements Analysis | Chapter 10 | 28 | ||
| 20 | 9 | ER Modeling (Top-down) | Section 11-11.5 | 14 | 7 | October 27 |
| 22 | 9 | ER Modeling | Section 11.6-11.7 | 10 | ||
| 27 | 10 | Normalization | Section 13-13.2 | 4 | ||
| 29 | 10 | Functional dependencies | Section 13.3 | 6 | ||
| November | ||||||
| 3 | 11 | 1NF - 3NF | Section 13.4-13.7 | 11 | ||
| 5 | 11 | BCNF - 5NF | Section 13.8-13.12 | 14 | 8 | November 19 |
| 10 | 12 | Topics: Conceptual and Logical Design | Chapter 14,15, Appendix F | 42 | ||
| 12 | 12 | Topics: Physical Design, Physical Storage | Chapter 16, Appendix C | 44 | ||
| 17 | 13 | Topics: Security | Section 18.1, 18.2, 18.5 | 20 | ||
| 19 | 13 | Topics: Transaction Management | Chapter 19 | 47 | ||
| 24 | 14 | Topics: Query Optimization | Chapter 17, 20 | 48 | ||
| 26 | 14 | No Class | ||||
| December | ||||||
| 1 | 15 | Topics: Distributed Databases | Chapter 22 | 43 | ||
| 3 | 15 | Topics: Data Warehouses | Chapter 30, 31 | 40 | ||
| 8 | Take-home Exam Due | |||||
| 11 | Project Due |
Database Systems: A practical approach to design, implementation, and management, third edition by Thomas Connolly and Carolyn Begg. Addison-Wesley Publisher, 2002. ISBN: 0201708574
| Lab |
Assignment |
Date Due |
|---|---|---|
| 1 | Set up a CEC and WebDev Account; Create the table(s) described in Exercise 1.9. Submit a jpg showing the table design. | September 15 |
| 2 | Import the project data file into a database | September 20 |
| 3 | Write queries to identify products with similar ingredients | October 12 |
| 4 | Write queries to identify all products with the same ingredients as a specific product | October 31: Code samples added |
| 5 | Identify functional dependencies that violate 2NF and normalize tables | November 10 |
| 6 | Identify functional dependencies that violate 3NF and normalize tables | November 17 |
| 8 | Design a B+-tree and write an algorithm for finding a record | December 1 |
Using the DBMS of your choice. Microsoft SQL Server and Microsoft Access are supported by the CEC.
This is for exploration. You will need to assign column names that match between the tables and sql statements.
| Component | Percent of Grade |
|---|---|
| In-class Exam (1) | 20 |
| Take-home Exam (1) | 20 |
| Project (1) | 20 |
| Homework (~40 questions) | 20 |
| Lab Homeworks (8) | 20 |