ASSIGNMENT #3: Clustering & OLAP | EECS-4412M : Data Mining | winter term 2023 | York University

The Assignment

Q1: Clustering [5pt]

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`

psql: PostgreSQL's shell client

Q2: OLAP Queries [10pt]

Resources

Deliverables