Skip to content
CS 374, Spring 2024
EER Wrap-Up Quiz
Initializing search
Home
Syllabus
Calendar
Homework
Labs
Notes
CS 374, Spring 2024
Home
Syllabus
Calendar
Homework
Homework
HW1: Soccer League
HW2: Conference Review
HW3: Workbench Model
HW4: CRUD Operations
HW5: Basic SQL Queries
HW6: Intermediate SQL
GP1: Hotel ER Modeling
GP2: Relational Mapping
GP3: Create Sample Data
GP4: Queries and Charts
GP5: Database Updates
GP6: Final Presentation
Labs
Labs
Abstract ER Model
Vehicle Rental EER
EER Wrap-Up Quiz
SQLite (DB Browser)
MySQL Workbench
Forward Engineering
mysql Command Line
Soccer Database Updates
pgAdmin Postgres Tools
psql Interactive Terminal
postgres_air Database
Normalization Exercises
Flask Setup (VS Code)
Notes
Notes
Week 1: Introduction
Week 1: Introduction
Jan 16: Getting Started
Jan 18: Course Overview
Week 2: ER / EER Models
Week 2: ER / EER Models
Jan 23: ER Models
Jan 25: EER Models
Week 3: Relational Model
Week 3: Relational Model
Jan 30: EER Wrap-Up
Feb 01: Intro to SQLite
Week 4: EER to Relational
Week 4: EER to Relational
Feb 06: Assessment Day
Feb 08: Relational Mapping
Week 5: DDL and DML
Week 5: DDL and DML
Feb 13: Creating Tables
Feb 15: Modifying Data
Week 6: SQL: Basics
Week 6: SQL: Basics
Feb 20: GROUP BY, Aggregation
Feb 22: JOINS, DISTINCT, psql
Week 7: SQL: Complex
Week 7: SQL: Complex
Feb 27: Subqueries, Set Operations
Feb 29: Query Optimization
Week 8: Midterm Exam
Week 8: Midterm Exam
Mar 05: Review Weeks 1–7
Mar 07: Midterm Exam
Week 9: Normalization
Week 9: Normalization
Mar 19: Functional Dependencies
Mar 21: Normal Forms (3NF and BCNF)
Week 10: Data Storage
Week 10: Data Storage
Mar 26: GP1 Feedback, GitHub
Mar 28: Storage, GP2 Scripts
Week 11: Web Applications
Week 11: Web Applications
Apr 02: GP2 Feedback, Flask
Apr 04: Creating Data, DB-API
Week 12: DB Programming
Week 12: DB Programming
Apr 09: SQL Functions, Table Charts
Apr 11: SQL Injection, Debugging
Week 13: Transactions
Week 13: Transactions
Apr 16: GP4 Feedback, Transactions
Apr 18: Transactions in Python/Flask
Week 14: NoSQL Databases
Week 14: NoSQL Databases
Apr 23: GP5 Feedback, Big Data
Apr 25: MongoDB, Non-Relational
Week 15: Course Wrap-Up
Week 15: Course Wrap-Up
Apr 30: Project Presentations
May 02: Review for Final Exam
EER Wrap-Up Quiz
Complete this handout with your group:
EER_Quiz.pdf
Back to top