jackmyers.info
Schedule for DB
| Week of (Mon) | Monday | Tuesday | Wednesday | Thursday | Assignments |
|---|---|---|---|---|---|
| 5/18 |
1. Introduction to Databases 2. Data Modeling Modeling our Movie Database in Access and Using the Query Wizard Chapter 3: Data Modeling Using the ER Model |
2. Data Modeling Section Tally Modeling Chapter 3: Data Modeling Using the ER Model n-ary relationships Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm |
2. Data Modeling Chapter 4: The Enhanced ER (EER) Model Section 9.2: Mapping EER Model Constructs to Relations |
2. Data Modeling 3. Keys, SELECT and demonstration of joins Chapter 5: The Relational Data Model and Relational DB Constraints Section 6.3: Basic Retrieval Queries in SQL Section 7.1.6: Joined Tables in SQL and Outer Join |
ASSIGNMENT DUE: 5/28 Complete exercise 3.22 in the text. Upload your Chen-based ER diagram, and a Word file stating the assumptions you have made. For this exercise, you must use a Baseball team. The score should be clear. |
| 5/25 | Memorial Day |
3. Inner Joins Section 6.3: Basic Retrieval Queries in SQL Section 7.1.6: Joined Tables in SQL and Outer Join |
4. Database Programming (procedures, triggers) Chapter 10: Introduction to SQL Programming Techniques Chapter 11: Web Database Programming Using PHP |
4. Database Programming (functions, PHP) Chapter 10: Introduction to SQL Programming Techniques Chapter 11: Web Database Programming Using PHP |
ASSIGNMENT DUE: 6/3 Building a database for Research Papers Create the tables and constraints for a citation management system. Populate the tables. **ASSIGNMENT START |
| 6/1 |
5. Advanced SQL: Outer Joins, UNIONS, Aggregation Section 7.1.6: Joined Tables in SQL and Outer Join Section 7.1.7: Aggregate Functions in SQL Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses |
5. Advanced SQL: Self-Join Review (Composite parts exercise) 6. Subqueries Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE |
6. Subqueries Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE |
SQL Lab |
TEST SQL and Modeling |
| 6/8 |
7. MongoDB Chapter 24: NoSQL DBs and Big Data Storage Systems |
7. MongoDB Chapter 24: NoSQL DBs and Big Data Storage Systems |
7. MongoDB Aggregation Framework Chapter 24: NoSQL DBs and Big Data Storage Systems 8. Normalization Funct Dependencies, Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
NO CLASSS |
ASSIGNMENT DUE: 6/22 MongoDB |
| 6/15 |
8. Normalization 1NF-2NF
BCNF - 6NF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
8. Normalization 3NF-5NF
BCNF - 6NF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
8. Normalization 5NF-6NF
BCNF - 6NF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB 10. Performance: Indexes & Explain Chapter 17: Indexing Structures for Files and Physical DB design |
11. NoSQL: Neo4j Chapter 24: NoSQL DBs and Big Data Storage Systems O'Reilly Text: Neo4j Neo4j |
ASSIGNMENT DUE: 6/25 Neo4j |
| 6/22 |
9. Views Section 29.6 Data Warehouse vs. Views |
12. Transactions and Locking Chapter 20: Introduction to Transaction Processing Concepts and Theory |
13. DB Security
Chapter 30: Database Security |
Final Exam |