jackmyers.info

Schedule for DB

Week of Monday Wednesday Assignments
9/2 Labor Day 1. Introduction to Databases
2. 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
ASSIGNMENT DUE: 9/9
Getting setup for class
9/9 2. Data Modeling

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

Section Tally Modeling


Chapter 3: Data Modeling Using the ER Model
Read chapter 9

ASSIGNMENT DUE: 9/23
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.
9/16 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
2. Data Modeling
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
Read chapters 5, 6
9/23 2. Data Modeling
(final thoughts, if needed)

MySQL Workbench: queries, table creation, data population, primary and foreign keys


3. Keys, SELECT and inner joins
Chapter 5: The Relational Data Model and Relational DB Constraints
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

ASSIGNMENT DUE: 9/30
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)

9/30 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
4. Database Programming
    Procedures/Functions/Triggers

Chapter 10: Introduction to SQL Programming Techniques
Read chapter 7
TEST 1: Data Modeling
10/7 4. Database Programming
    PHP

5. Adv. SQL: Outer Joins, UNIONS,

Section 7.1.6: Joined Tables in SQL and Outer Join

Joining Tables in Adventureworks

10/14 5. Advanced Queries:
    Aggregation Queries

Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
6. Subqueries:
Sections 7.1.2: Nested Queries
PROJECT DUE: 10/21
PHP — Research Paper System
10/21 6. Subqueries:
    Correlated Queries

Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE

Subqueries in AdventureWorks


7. NoSQL, CAP Theorem,
    Intro to MongoDB

Chapter 24: NoSQL DBs and Big Data Storage Systems
**ASSIGNMENT END: Due 10/25
SQL Self Study Assignment(s)
TEST 2: SQL
10/28 7. MongoDB
8. Normalization
    Intro to Funct. Dependencies

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
Read chapter 14

11/4 8. Normalization
    Funct. Dependencies, 1NF, 2NF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
8. Normalization
    3NF to BCNF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
Read chapter 29

PROJECT DUE: 11/11 MongoDB
11/11 8. Normalization
    BCNF, higher forms
9. Views
Section 29.6 Data Warehouse vs. Views
ASSIGNMENT DUE: 11/18
Views, Materialized Views and Triggers
11/18 TBD 10. Performance: Indexes
Chapter 17: Indexing Structures for Files and Physical DB design
Read chapter 17, 24
11/25 10. Performance: Indexes and Explain
Chapter 17: Indexing Structures for Files and Physical DB design
11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

Read chapter 20

12/2 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

PROJECT DUE 12/9: Neo4j database
12/9 13. DB Security
Chapter 30: Database Security
Finals Week



Modified: