jackmyers.info

Schedule for DB

Week of (Tues) Tuesday Wednesday Assignments
6/4 1. Introduction to Databases
2. Data Modeling


Modeling our Movie Database in Access and Using the Query Wizard


Chapter 3E: Data Modeling Using the ER Model
2. Data Modeling

Section Tally Modeling


Chapter 3E: Data Modeling Using the ER Model
n-ary relationships
Section 9.1E: Relational DB Design Using ER-Relational Mapping Algorithm
ASSIGNMENT DUE: 6/11
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.
6/11 2. Data Modeling
Chapter 4E: The Enhanced ER (EER) Model
Section 9.2E: Mapping EER Model Constructs to Relations
2. Data Modeling (leftover)

3. Keys, SELECT and Inner Join
Chapter 3M: The Relational Data Model
Chapter 4M: Query Formulation with SQL
ASSIGNMENT DUE: 6/25
Building a database for Research Papers
Create the tables and constraints for a citation management system. Populate the tables.

**ASSIGNMENT START
You can begin the SQL Self Study Assignment(s)

6/18 3. Inner Join (review)
Chapter 4M: Query Formulation with SQL

4. Database Programming
Chapter 11M: Stored Procedures and Triggers
4. Database Programming (functions, PHP)

5. Advanced SQL: Outer Joins, UNIONS,
     Aggregation

Chapter 4M: Query Formulation with SQL
Chapter 9M: Advanced Query Formulation with SQL
TEST 1: 6/23-6/24 Database Concepts and Modeling
6/25 5. Advanced SQL: Outer Joins, UNIONS,
     Aggregation

Chapter 4M: Query Formulation with SQL
Chapter 9M: Advanced Query Formulation with SQL

6. Subqueries
Chapter 9M: Advanced Query Formulation with SQL
6. Subqueries
     Correlated Subqueries
Chapter 9M: Advanced Query Formulation with SQL

7. CAP Theorem
PROJECT DUE: 7/2
PHP — Research Paper System
7/2 7. NoSQL: MongoDB
8. Normalization
    Intro to Funct. Dependencies, 1NF, 2NF

Chapter 7M: Normalization Concepts and Processes
8. Normalization
    3NF, BCNF, 4NF - 6NF

Chapter 7M: Normalization Concepts and Processes
**ASSIGNMENT END: Due 7/9
SQL Self Study Assignment(s)
TEST 2: SQL
7/9 8. Normalization Review
     Denormalization

Chapter 7M: Normalization Concepts and Processes
9. Views
Section 10M: App Development Using Views
Updateable Views
Section 15.4M: Summary Data Management and Optimization
9. Views
Section 10M: App Development Using Views
Section 15.4M: Summary Data Management and Optimization
PROJECT DUE: 7/16
MongoDB
7/16 10. Performance: Indexes & Explain
11. NoSQL: Neo4j a Graph DB
O'Reilly Text: Neo4j

Neo4j

ASSIGNMENT DUE: 7/23
Views, Materialized Views and Triggers
7/23 12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
13. DB Security
PROJECT DUE: 7/30
Neo4j
7/30 Final Exam


Sources:


Modified: