jackmyers.info
Schedule for DB
Week of (Tues) | Tuesday | Thursday | Assignments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
9/6 |
1. Introduction to Databases 2. Data Modeling Modeling our Movie Database and Using the MySQL Workbench Wizard |
2. Data Modeling
Chapter 3: Data Modeling Using the ER Model (n-ary relationships) |
Read chapters 3, 4, 9 |
||||||||
9/13 |
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 Chapter 4: The Enhanced ER (EER) Model Section 9.2: Mapping EER Model Constructs to Relations |
2. Data Modeling MySQL Workbench: queries, table creation, data population, primary and foreign keys |
Read chapters 5, 6
ASSIGNMENT DUE: 9/21 Baseball Modeling A database is being constructed to keep track of the teams and games of a baseball sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER schema diagram for this application, stating any assumptions you make. |
||||||||
9/20 | 3. Keys, SELECT and inner joins
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 10/3; 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 |
|||||||||
9/27 | 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 |
Modeling Test | Read chapter 7
TEST 1: Data Modeling |
||||||||
10/4 | 5. Adv. SQL: Outer Joins, UNIONS, Section 7.1.6: Joined Tables in SQL and Outer Join Joining Tables in Adventureworks |
4. Database Programming Procedures/Functions Chapter 10: Introduction to SQL Programming Techniques |
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 ; Graded with final project. PHP — Research Paper System |
|||||||
10/11 | 4. Database Programming Triggers Chapter 10: Introduction to SQL Programming Techniques |
4. Database Programming PHP |
|||||||||
10/25 | 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 |
|||||||||
11/1 | 7. NoSQL, CAP Theorem, Intro to MongoDB Chapter 24: NoSQL DBs and Big Data Storage Systems |
7. MongoDB
|
Read chapter 14 ASSIGNMENT DUE: MongoDB |
||||||||
11/8 |
8. Normalization Intro to Funct. Dependencies Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
8. Normalization Funct. Dependencies, 1NF, 2NF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
Read chapter 29 | ||||||||
11/15 |
8. Normalization 3NF to BCNF
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
8. Normalization BCNF, higher forms
|
PROJECT Part 3: Graded with final project via appointment when completed. Views, Materialized Views and Triggers |
||||||||
11/22 | 9. Views Section 29.6 Data Warehouse vs. Views | Thanksgiving | Read chapter 17, 24 | ||||||||
11/29 | 11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems O'Reilly Text: Neo4j Neo4j |
10. Performance: Indexes and Explain
Chapter 17: Indexing Structures for Files and Physical DB design |
Read chapter 20 |
||||||||
12/1 | 12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory | 12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory |
Read chapter 30 ASSIGNMENT DUE : Neo4j database |
||||||||
12/13 | 13. DB Security
Chapter 30: Database Security |
Finals Week begins |