Bummer! This is just a preview. You need to be signed in with an account to view the entire instruction.

Instruction

Explore Data Relationships in a SQL Database

Before we represent our application's nouns in the database using multiple tables, let's look at what a single "Movies" table might look like if we embedded each movie's director information.

Why Data Relationships are Useful

Here's a column list for a basic Movies table:

Movies Table

Column Data Type
id INTEGER, PRIMARY KEY
title VARCHAR(255)
releaseYear ...