Skip to content

README.md

Latest commit

 

History

History
21 lines (15 loc) · 780 Bytes

README.md

File metadata and controls

21 lines (15 loc) · 780 Bytes

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)