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 (review and pracice)

3. Keys, SELECT and demonstration of joins
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 Joins
Chapter 4M: Query Formulation with SQL

4. Database Programming (procedures, triggers)
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
5. Advanced SQL: Self-Join Review
     (composite parts exercise)

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

6. Subqueries
Chapter 9M: Advanced Query Formulation with SQL
PROJECT DUE: 7/9
PHP — Research Paper System
7/2 6. Subqueries
Chapter 9M: Advanced Query Formulation with SQL
6. Subqueries
     Correlated Subqueries
Chapter 9M: Advanced Query Formulation with SQL
7. NoSQL: CAP Theorem and Intro to MongoDB
**ASSIGNMENT END: Due 7/9
SQL Self Study Assignment(s)
TEST 2: SQL
7/9 7. MongoDB 8. Normalization
    Funct Dependencies, 1NF - 3NF

Chapter 7M: Normalization Concepts and Processes
PROJECT DUE: 7/23
MongoDB
7/16 8. Normalization
    Funct Dependencies, BCNF - 6NF

Chapter 7M: Normalization Concepts and Processes
9. Views
Section 10M: App Development Using Views
Section 15.4M: Summary Data Management and Optimization
10. Performance: Indexes & Explain
ASSIGNMENT CANCELLED
Views, Materialized Views and Triggers
7/23 11. NoSQL: Neo4j a Graph DB
O'Reilly Text: Neo4j

Neo4j

12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
PROJECT DUE: 7/30
Neo4j
7/30 13. DB Security
Take Home Final Exam


Sources:


Modified: