# Planning for Week 8

## High Level Topic Summary

>  - Relational Model and Structure
>  - SQL Language
>  - Single Table SQL
>      - Access Operations (rows and columns)
>      - Partitioning and Aggregation

## Readings for the week

Day        | Reading      | Reading Questions
:--------- |:-------------|:----------------------------------
Monday     | Chapter 10 (all) | None
Tuesday    | - |
Wednesday  | Chapter 11, 11.1 through 11.4 | none
Friday     | Chapter 11, 11.5 and 11.6 | 11.69, 11.78, 11.80, 11.85

## Projected Class and Homework

HW | Day Out  | Day Due | Contents
:--|:--------|:--------|:------------------------------------
` ` | Tuesday | Wednesday | Tableau Practicum Turnin
HW_3.1 | Wednesday | Friday | Single Table SQL Access Operations
HW_3.2 | Friday | Monday | Single Table Partitioning and Aggregation

## Tuesday Problem Day

Combination of the following:

- SQL database access/setup
- Tableau practicum

## Progression

This week, we begin the third of our data models covering the *forms* of data treated in this course, namely the *relational database model*.  In addition, we move from our exclusive use of local files as the *source* of our data to one where the data may be maintained and shared over a network where a server hosts the relational database.

Monday will highlight the most important aspects of the model, with its structure and typical architectures.  We will introduce and define many terms we will need over the next three weeks.  Monday's treatment will give a glimpse at one of the core advantages of databases: **design before data population**.

Wednesday and Friday will focus on the SQL language and its use in declaring the data desired from single tables in a database, from column projection and row selection to computing on column-vectors of a result to performing partitioning and aggregation.