jackmyers.info

Schedule for DB

Week of (Mon) Monday Tuesday Wednesday Thursday Assignments
5/18 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
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
Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations
2. Data Modeling

3. Keys, SELECT and demonstration of joins
Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL
Section 7.1.6: Joined Tables in SQL and Outer Join
ASSIGNMENT DUE: 5/28

Complete exercise 3.22 in the text. Upload your Chen-based ER diagram, and a Word file stating the assumptions you have made.


For this exercise, you must use a Baseball team. The score should be clear.

5/25 Memorial Day 3. Inner Joins
Section 6.3: Basic Retrieval Queries in SQL Section 7.1.6: Joined Tables in SQL and Outer Join
4. Database Programming (procedures, triggers)
Chapter 10: Introduction to SQL Programming Techniques
Chapter 11: Web Database Programming Using PHP
4. Database Programming (functions, PHP)
Chapter 10: Introduction to SQL Programming Techniques
Chapter 11: Web Database Programming Using PHP
ASSIGNMENT DUE: 6/3
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/1 5. Advanced SQL: Outer Joins, UNIONS, Aggregation
Section 7.1.6: Joined Tables in SQL and Outer Join
Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
5. Advanced SQL: Self-Join Review
(Composite parts exercise)

6. Subqueries
Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE
6. Subqueries
Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE
SQL Lab TEST SQL and Modeling
6/8 7. MongoDB
Chapter 24: NoSQL DBs and Big Data Storage Systems
7. MongoDB
Chapter 24: NoSQL DBs and Big Data Storage Systems
8. Normalization
    Funct Dependencies,
    1NF - 3NF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
8. Normalization
    Funct Dependencies,
    BCNF - 6NF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
ASSIGNMENT DUE: 6/17
MongoDB
6/15 Overflow period 9. Views
Section 29.6 Data Warehouse vs. Views
10. Performance: Indexes & Explain
Chapter 17: Indexing Structures for Files and Physical DB design
11. NoSQL: Neo4j
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

ASSIGNMENT DUE: 6/24
Neo4j
6/22 In class workshop: Views, Materialized Views and Triggers 12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
13. DB Security
Chapter 30: Database Security
Final Exam



Modified: