We look at primary keys, logical keys and foreign keys. We look at how foreign keys are represented in the database.

We look at how we map a logical database model to a physical database model by adding columns and constraints to model the table-to-table relationships.

We look at how to reconstruct complete views of the data when data is properly distributed across multiple tables and connected via foreign keys. We learn the JOIN operation and ON clause in SQL.

We work through a track data example with four tables.

We look at how to build a connector table to represent many-to-many relationships such as students and courses in database tables. We also learn about composite primary keys.

We extend the Twitter example to represent friends using Many-to-Many relationships.

In this assignment we make use of the Google GeoCoding API to look up addresses, store the data in a database and then use Google Maps to visualize the data.

Worked Example: Retrieving Geocoded Data

We build a web crawler that retrieves web pages and links from those pages an copies the pages into the database. Once we have retrieved our web data we run a simple Page Rank algorithm on the data and visualize the results.

Worked Example: A Web Crawler