Previously: cs460-databases

CS460 — Introduction to Database Systems

SQL queries and database projects from BU CS460 (Introduction to Database Systems). Covers relational algebra, SQL, query optimization, and database design.

Contents

File	Description
pa1-1a.sql	Project Assignment 1 — schema creation and data definition
hw2_queries.sql	Homework 2 — complex SQL queries (joins, subqueries, aggregation)
cs460_wa2.ipynb	Written Assignment 2 — database theory and query analysis

Topics Covered

• Relational model and schema design
• SQL (DDL, DML, complex queries)
• Joins, subqueries, aggregation
• Query optimization
• B+ tree indexing (see bplustree-cpp)