jackmyers.info
Schedule for DB
Week of | Tuesday | Thursday | Assignments | ||
---|---|---|---|---|---|
1/20 |
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 Chapter 3: Data Modeling Using the ER Model |
Read chapters 3, 4
ASSIGNMENT DUE: 1/27 Getting setup for class |
||
1/27 |
2. Data Modeling Section Tally Modeling 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 |
Read chapter 9 ASSIGNMENT DUE: 2/5 Complete exercise 3.22 in the textbook. Upload your Chen-based ER diagram, a screen shot of the physical model from Access, the Access database you have created, and a Word file that states the assumptions you have made. For this exercise, you must use a Baseball team. |
||
2/3 |
2. Data Modeling Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm Chapter 4: The Enhanced ER (EER) Model Section 9.2: Mapping EER Model Constructs to Relations |
2. Data Modeling (final thoughts, if needed) MySQL Workbench: queries, table creation, data population, primary and foreign keys 3. Keys, SELECT and inner joins Chapter 5: The Relational Data Model and Relational DB Constraints |
Read chapters 5, 6 | ||
2/10 |
3. Keys, SELECT and inner joins Chapter 5: The Relational Data Model and Relational DB Constraints Section 6.3: Basic Retrieval Queries in SQL |
3. SELECT, inner joins, variables MySQL Workbench, Sakila and AdventureWorks queries Chapter 5: The Relational Data Model and Relational DB Constraints Section 6.3: Basic Retrieval Queries in SQL |
Read chapter 10 PROJECT Part 1: Submission due 2/17; Graded with final project. Building a database for Research Papers Create the tables and constraints for a citation management system. Populate the tables. **ASSIGNMENT START |
||
2/17 |
4. Database Programming Procedures/Functions/Triggers Chapter 10: Introduction to SQL Programming Techniques |
4. Database Programming PHP |
Read chapter 7 TEST 1: Data Modeling |
||
2/24 |
5. Adv. SQL: Outer Joins, UNIONS, Section 7.1.6: Joined Tables in SQL and Outer Join Joining Tables in Adventureworks |
5. Advanced Queries: Aggregation Queries Section 7.1.7: Aggregate Functions in SQL Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses |
PROJECT Part 2: Submission due 3/2; Graded with final project. PHP — Research Paper System |
||
3/2 |
6. Subqueries: Sections 7.1.2: Nested Queries |
6. Subqueries: Correlated Queries Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE Subqueries in AdventureWorks |
**ASSIGNMENT END: Due 3/9 SQL Self Study Assignment(s) |
||
3/9 | TEST 2: SQL |
7. NoSQL, CAP Theorem, Intro to MongoDB Chapter 24: NoSQL DBs and Big Data Storage Systems |
|||
3/16 | Spring Break | ||||
3/23 | Spring Break | ||||
3/30 |
7. MongoDB |
8. Normalization Intro to Funct. Dependencies Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
Read chapter 14 ASSIGNMENT DUE: 4/17 MongoDB |
||
4/6 |
8. Normalization Funct. Dependencies, 1NF, 2NF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
8. Normalization 3NF to BCNF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
Read chapter 29 |
||
4/13 |
8. Normalization BCNF, higher forms |
9. Views Section 29.6 Data Warehouse vs. Views |
PROJECT Part 3: DUE: 4/27. Views, Materialized Views and Triggers |
||
4/20 |
10. Performance: Indexes Chapter 17: Indexing Structures for Files and Physical DB design |
10. Performance: Indexes and Explain Chapter 17: Indexing Structures for Files and Physical DB design |
Read chapter 17, 24 | ||
4/27 |
11. NoSQL: Neo4j a Graph DB Chapter 24: NoSQL DBs and Big Data Storage Systems O'Reilly Text: Neo4j Neo4j |
12. Special Topics Chapter 20: Introduction to Transaction Processing Concepts and Theory Chapter 30: Database Security |
Read chapter 20 and chapter 30 ASSIGNMENT 5/4: Neo4j database |
||
5/4 | Finals Week | Finals Week |