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
Joining Tables in Adventureworks

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.