Project #2: Tipping Point | EECS-4411A : Database Management Systems | fall term 2022 | York University

Introduction

The StL Data Warehouse

`Customer`
`custid`	`INTEGER`
`country`	`VARCHAR(20)`
`province`	`VARCHAR(20)`
`city`	`VARCHAR(20)`

`Book`
`bookid`	`INTEGER`
`language`	`VARCHAR(20)`
`genre`	`VARCHAR(20)`
`publisher`	`VARCHAR(40)`
`price`	`DECIMAL(5, 2)`

`Purchase`
`custid`	`INTEGER`
`bookid`	`INTEGER`
`whenp`	`DATE`
`qnty`	`INTEGER`
`sale`	`DECIMAL(6, 2)`

`Time`
`year`	`YEAR`
`month`	`MONTH`
`day`	`DAY`

Profiling Query Plans

psql: PostgreSQL's shell client

The Tasks

Frequently Asked Questions (FAQ)

Deliverables