jackmyers.info

Schedule for Databases

Class on Lesson Topics Work Due
Wed 9/5 or
Mon 9/10
F Syllabus Review
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
Wed 9/12 or
Mon 9/17
F




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
SQL
Introduction to JOINS and VIEWS
Wed 9/19 or
Mon 9/24
G

SQL
From SELECTs to Subqueries
Wed 9/26 or
Mon 10/1

D

A
B
DB-level Programming
Chapter 10: Functional Programming at DB Level: Procedures and Triggers
ORM
Python, MySQL and SQLAlchemy
Java, Oracle and JPA
ASSIGNMENT DUE: 10/7 (per individual)
Querying Jake's List - SQL
Wed 10/3 or
Mon 10/8
Paper Presentations (45 minutes each)

WedMon
  • Team 2 (Rath / Truong) - LIBKIN
  • Team 6 (Fletcher) - DECANDIA
  • Team 7 (Binaco / Quinn) - MEHMOUD
  • Team 1 (Chandrasekaran / Parmar) - DECANDIA
  • Team 3 (Dibona / SmitH) - PAPADIMITRIOU
  • Team 5 (Malitsky / Price) - ELGHAMRAWY
Wed 10/10 or
Mon 10/15
Functional Dependencies and Normalization
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
Wed 10/17 or
Mon 10/22
Paper Presentations (45 minutes each)

WedMon
  • Team 1 (Lueder / May) - ARNOLD
  • Team 11 (Carberry / Bhakta) - MAATUK
  • Team 2 (Pileckis) - DINARI
  • Team 4 (Luke / Pilla) - YANG
  • Team 6 (Smyth / Patel - HUANG
Wed 10/24 or
Mon 10/29
C

E
Managing Spatial Data
Flask framework
ASSIGNMENT DUE: (per project group)
ORM #1 - Python, MySQL, SQLAlchemy
ASSIGNMENT NO LONGER 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)

WedMon
  • Team 10 (Barraclough / Kazazi) - DINARI
  • Team 8 (Scavetta 2) - CARUCCIO
  • Team 12 (Carrier / Denoble) - HUANG
  • Team 7 (Richeal / Armstrong) - MAATUK
  • Team 8 (Huang / Rodriguez) - LIBKIN
  • Team 9 (Kalatsjov / Santos) - CARUCCIO
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
Wed 11/14 Paper Presentations (45 minutes each)

Wed
  • Team 5 (Motamedi / Nguyen)
  • Team 4 (Alacqua / Koval) - VASSILIOU
  • Team 3 (Genov / Lynn) - ELGHAMRAWY
ASSIGNMENT DUE: (per individual)
Walking in Medford Lakes (Geospatial DB)
Mon 11/19
or
Wed 11/21
Optional Class - review / project help / etc. 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


Chapter references from Fundamentals of Database Systems, 7th Edition, Ramez Elmasri & Shamkant B. Navathe, 2016.