jackmyers.info

Schedule for DB

Week of

Monday

Wednesday

Assignments

8/30

No school yet

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: 1/27
Getting setup for class

9/6

Labor Day

2. Data Modeling

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)

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

Read chapter 9

ASSIGNMENT DUE: 2/5
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/13

2. Data Modeling

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)
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)

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

2. Data Modeling

RDBMS 1.11 Converting an EER diagram to a Physical Model.mp4	(16:00)
RDBMS 1.12 Union types.mp4	(12:42)

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

Read chapters 5, 6

9/27

3. Keys, SELECT and inner joins

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

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

Read chapter 10

PROJECT Part 1: Submission due 2/17;
Graded with final project.
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)

10/4

4. Database Programming
Procedures/Functions/Triggers

Chapter 10: Introduction to SQL Programming Techniques

4. Database Programming
PHP

Read chapter 7

TEST 1: Data Modeling

10/11

5. Adv. SQL: Outer Joins, UNIONS,

Section 7.1.6: Joined Tables in SQL and Outer Join

Joining Tables in Adventureworks

5. Advanced Queries:
Aggregation Queries

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

PROJECT Part 2: Submission due 3/2;
Graded with final project.
PHP — Research Paper System

10/18

6. Subqueries:

Sections 7.1.2: Nested Queries

6. Subqueries:
Correlated Queries

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

Subqueries in AdventureWorks

**ASSIGNMENT END: Due 3/9
SQL Self Study Assignment(s)

10/25

7. NoSQL, CAP Theorem,
Intro to MongoDB

Chapter 24: NoSQL DBs and Big Data Storage Systems

7. MongoDB

TEST 2 take home

11/1

8. Normalization
Intro to Funct. Dependencies

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

8. 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

Read chapter 14

ASSIGNMENT DUE: 3/30 MongoDB

11/8

8. 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

8. Normalization
BCNF, higher forms

RDBMS 2.09 Higher Normal Forms.mp4

(10:54)

Read chapter 29

11/15

No class

9. Views
Section 29.6 Data Warehouse vs. Views

PROJECT Part 3: Graded with final project via appointment when completed.

Views, Materialized Views and Triggers

11/22

10. Performance: Indexes

Chapter 17: Indexing Structures for Files and Physical DB design

10. Performance: Indexes and Explain

Chapter 17: Indexing Structures for Files and Physical DB design

Read chapter 17, 24

11/29

11. NoSQL: Neo4j a Graph DB

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

Neo4j

12. Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory

Read chapter 20

12/6

12. Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory

13. DB Security

Chapter 30: Database Security

Read chapter 30

ASSIGNMENT DUE 4/27: Neo4j database

12/13

Finals Week