jackmyers.info

Schedule for Databases

Class on Lesson Topics Work Due
Wed 9/5 or
Mon 9/10
Data Modeling
Chapter 3: Data Modeling Using the ER Model
Data Modeling Jake's List
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
Wed 9/12 or
Mon 9/17
Data Modeling
Review / Questions?
SQL
Chapter 6: Basic SQL
Chapter 7: More SQL
Wed 9/19 or
Mon 9/24
D


A
SQL
Chapter 10: Functional Programming at DB Level: Procedures and Triggers
ORM
Python, MySQL and SQLAlchemy
Wed 9/26 or
Mon 10/1
Functional Dependencies and Normalization
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
ASSIGNMENT DUE: (per individual)
Querying Jake's List - SQL
Wed 10/3 or
Mon 10/8
Paper Presentations (45 minutes each)
  • Team 1
  • Team 2
  • Team 3
Wed 10/10 or
Mon 10/15
B ORM
Java, Oracle and JPA
ASSIGNMENT DUE: (per project group)
ORM #1 - Python, MySQL, SQLAlchemy
Wed 10/17 or
Mon 10/22
Paper Presentations (45 minutes each)
  • Team 4
  • Team 5
  • Team 6
Wed 10/24 or
Mon 10/29
C

E
Managing Spatial Data
Flask framework
ASSIGNMENT DUE: (per project group)
ORM #2 - Lucy and friends starts a buisness (Java, Oracle, JPA)
Wed 10/31 or
Mon 11/5
Paper Presentations (45 minutes each)
  • Team 7
  • Team 8
  • Team 9
Wed 11/7 or
Mon 11/12
File Structures
Chapter 16: Data Storage, Basic File Structures, Hashing...
Chapter 17: Indexing Structures for Files and Physical DB design
ASSIGNMENT DUE: (per individual)
Walking in Medford Lakes (Geospatial DB)
Wed 11/14 or
Mon 11/19
Wed 11/21 no class
Paper Presentations (45 minutes each)
  • Team 10
  • Team 11
  • Team 12
Thanksgiving
Mon 11/26 or
Wed 11/28
NOSQL Databases
Neo4j: A Graph Database

Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j
Mon 12/3 or
Wed 12/5
Project Presentations (30 minutes each)
  • Group 1
  • Group 2
  • Group 3
  • Group 4
Mon 12/10 or
Wed 12/12
Project Presentations (30 minutes each)
  • Group 5
  • Group 6
  • Group 7
  • Group 8
Mon 12/17 or
Wed 12/19
FINAL EXAM