jackmyers.info

Refactored Schedule for DB

Week of (Tues)

Tuesday

Wednesday

Assignments

9/5

1. Introduction to Databases

WebEx link: https://rowan.webex.com/rowan/j.php?MTID=m41983dbede1946f0de2491e2c3c85e0d

NO CLASS, but watch these videos for a quiz on Tuesday

RDBMS 1.00 Types of Database Models.mp4	(13:05)
RDBMS 1.01 Entity Types and Attributes.mp4	(5:51)
RDBMS 1.02 Relationships Cardinality and Participation.mp4	(11:54)
RDBMS 1.03 Unary or Recursive Relationships.mp4	(4:15)
RDBMS 1.04 n-ary Relationships.mp4	(14:20)
RDBMS 1.05 Weak Entity Types and Identifying Relationships.mp4	(8:43)
RDBMS 1.06 Attributes of Relationships.mp4	(2:56)

9/12

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

Quiz on ER Modeling (Chapter 3)

Practicing with Section Tally

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

Practice exercises on ER modeling

ASSIGNMENT (See due dates in Canvas)

Baseball Modeling

A database is being constructed to keep track of the teams and games of a baseball sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER schema diagram for this application, stating any assumptions you make.

9/19

2. Data Modeling

Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm

RDBMS 1.07a Converting an ER diagram to a Physical Model (part 1).mp4	(7:02)
RDBMS 1.07b Converting an ER diagram to a Physical Model (part 2).mp4	(14:11)
RDBMS 1.07c Converting an ER diagram to a Physical Model (part 3).mp4	(9:59)
RDBMS 1.07d Converting an ER diagram to a Physical Model (part 4).mp4	(12:18)

Converting ER diagrams to physical models

2. Data Modeling

Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations

RDBMS 1.08 The EER Diagram.mp4	(4:00)
RDBMS 1.09 Examining an EER Diagram.mp4	(9:23)
RDBMS 1.10 More about EER diagrams.mp4	(3:14)
RDBMS 1.11 Converting an EER diagram to a Physical Model.mp4	(16:00)
RDBMS 1.12 Union types.mp4	(12:42)

PROJECT Part 1 (See due dates in Canvas)
Graded with final project.

Building a database for Research Papers

Database creation
Create the tables and constraints for a citation management system. Populate the tables.

9/26

3. Keys, SELECT and inner joins

Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL

Review

10/3

5. Database Programming
Triggers

Chapter 10: Introduction to SQL Programming Techniques

4. Outer joins and UNIONs

Section 7.1.6: Joined Tables in SQL and Outer Join

TEST 1: Data Modeling

PROJECT Part 2 (See due dates in Canvas)
Graded with final project

SQL against an inheritant database

10/10

4. Outer joins and UNIONs

Section 7.1.6: Joined Tables in SQL and Outer Join

5. Database Programming
PHP

6. Aggregation and Windows Functions
Aggregation Queries

Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses

10/17

5. Database Programming
Procedures/Functions

Chapter 10: Introduction to SQL Programming Techniques

5. Database Programming
Triggers

Chapter 10: Introduction to SQL Programming Techniques

PROJECT Part 3: (See due dates in Canvas)
Graded with final project.

Database programming
PHP — Research Paper System

10/24

7. NoSQL, CAP Theorem,
Intro to MongoDB

Chapter 24: NoSQL DBs and Big Data Storage Systems

7. MongoDB

ASSIGNMENT (See due dates in Canvas)

MongoDB

10/31

7. MongoDB:
6. Aggregation and Windows Functions

8. Subqueries:

Sections 7.1.2: Nested Queries

11/7

8. Subqueries:
Correlated Queries

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

Subqueries in AdventureWorks

9. Normalization
Intro to Funct. Dependencies

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

11/14

9. Normalization
Funct. Dependencies, 1NF, 2NF

RDBMS 2.01 Functional Dependencies.mp4	(9:30)
RDBMS 2.02 Why Normalize.mp4	(15:53)
RDBMS 2.03 1st Normal Form.mp4	(12:56)
RDBMS 2.04 2nd Normal Form defined.mp4	(11:06)
RDBMS 2.05 Practicing 2nd Normal Form.mp4	(9:43)

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

TEST 2: SQL

11/21

9. Normalization
3NF to BCNF

RDBMS 2.06 3rd Normal Form.mp4	(11:45)
RDBMS 2.07 Practicing 3rd Normal Form.mp4	(9:46)
RDBMS 2.08 Boyce-Codd Normal Form.mp4	(13:00)

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

9. Normalization
BCNF, higher forms

RDBMS 2.09 Higher Normal Forms.mp4

(10:54)

11/28

10. Views
Section 29.6 Data Warehouse vs. Views

Thanksgiving

PROJECT Part 4: (See due dates in Canvas)
Graded with final project.

Materialized Views
Views, Materialized Views and Triggers

12/5

11. NoSQL: Neo4j a Graph DB

Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

12. Performance: Indexes and Explain

Chapter 17: Indexing Structures for Files and Physical DB design

ASSIGNMENT (See due dates in Canvas)

Neo4j

12/12

13. Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory

Reading Day