jackmyers.info
Schedule for Databases
Wednesday | Assignments | ||
---|---|---|---|
Week of | Lesson | Topics | Work Due |
9/6/2017 | 1, 2 |
Introduction to Databases Data Modeling Modeling our Movie Database in Access and Using the Query Wizard Chapter 3: Data Modeling Using the ER Model |
Read chapters 3, 4 |
9/13/2017 | 2 |
Data Modeling Chapter 3: Data Modeling Using the ER Model Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm From Section Tally to ER diagram: individual ERs, then group Chapter 4: The Enhanced ER (EER) Model |
Read chapter 9 ASSIGNMENT DUE: Complete exercise 3.22 in the textbook. Upload your ER diagram and a Word file that states the assumptions you have made. For this exercise, you must use a Baseball team. You do not have to upload the Access file, as we will be modifying this in the next assignment. Ready for Modeling Test |
9/20/2017 | 2 |
Data Modeling, Keys and SELECT Chapter 4: The Enhanced ER (EER) Model Section 9.2: Mapping EER Model Constructs to Relations TBD |
Read Chapter 5 |
9/27/2017 | 2, 3 |
Data Modeling, Keys and SELECT Section 9.2: Mapping EER Model Constructs to Relations MySQL Workbench, Sakila and AdventureWorks queries Chapter 5: The Relational Data Model and Relational DB Constraints Section 6.3: Basic Retrieval Queries in SQL |
ASSIGNMENT DUE: Extending the NL East Model (exercise 4.30) then take your EER NL East Model and build it in MS Access including data. Upload the Access file and the EER diagram. Due 10/6/2017 |
10/4 | 4 |
Variables and Inner Joins Chapter 7: More SQL... Section 7.1.6: Joined Tables in SQL and Outer Join Using variables in Sakila |
|
10/11 | 4 |
Outer Joins, Unions Section 7.1.6: Joined Tables in SQL and Outer Join Basic Queries in Adventureworks Aggregation Queries Section 7.1.7: Aggregate Functions in SQL Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses |
ASSIGNMENT DUE: AdventureWorks Basic SQL Due 10/11/2017 |
10/18 | 4, 5 |
Aggregation Section 7.1.7: Aggregate Functions in SQL Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses Joining Tables in Adventureworks Subqueries Sections 7.1.2: Nested Queries |
ASSIGNMENT DUE: JOINing in AdventureWorks |
10/25 | 5, 6 |
Subqueries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE Subqueries in AdventureWorks DDL and DML Sections 6.1. 6.2 & 6.3: DDL, Data Types, Constraints, DML |
ASSIGNMENT DUE: Aggregation in AdventureWorks |
11/1 | 7 |
Programming at DB Level: Procedures and Triggers Chapter 10: Introduction to SQL Programming Techniques Programming at Web Server Level Chapter 11: Web Database Programming Using PHP TBD |
ASSIGNMENT DUE: Subqueries in AdventureWorks |
11/8 | 8 |
Introduction to Functional Dependencies Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB Getting PHP to work on elvis |
Read Chapter 14 |
11/15 | 8 |
More Functional Dependencies and Data Normalization Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB TBD |
PROJECT DUE: PHP — AdventureWorks and Sakila on the Web |
11/22 | 9 |
NOSQL Databases —
MongoDB plus the CAP Theorem Appendix D: Overview of the Hierarchical Data Model Appendix E: Overview of the Network Data Model Chapter 24: NoSQL DBs and Big Data Storage Systems MongoDB |
Thanksgiving |
11/29 | 10 |
Query Optimization Chapter 18: Strategies for Query Processing TBD |
PROJECT DUE: MongoDB |
12/6 | 11 |
NOSQL Databases Neo4j: A Graph Database Chapter 24: NoSQL DBs and Big Data Storage Systems O'Reilly Text: Neo4j Neo4j |
Read Chapter 20 |
12/13 | 12 |
Transactions and Locking Chapter 20: Introduction to Transaction Processing Concepts and Theory TBD |
PROJECT DUE: Neo4j database |
Chapter references from Fundamentals of Database Systems, 7th Edition,
Ramez Elmasri & Shamkant B. Navathe, 2016.