Job Ready SQL

Lesson 8Pulling It All Together: Building the Vinyl Record Shop Database

In this code‐along lesson, you will work through the steps to create a database for a Vinyl Record Shop, a small business that specializes in vinyl albums. As you go through each step of creating the database structure, you should save the step to a SQL script. By the end of this lesson, you will have pulled together all the ideas learned to this point, and you will have a script that you can use (and reuse!) to create the Vinyl Record Shop database structure, including all tables and relationships, as defined in an ERD.

NOTE SQL scripts can be used for a variety of things including to back up an existing database or to transfer a database to another server.

Learning Objectives

By the end of this lesson, you will be able to:

• Review a database structure
• Build a database using SQL
• Determine the primary tables within a database
• Construct the related tables within a database
• Show the tables you have created and their fields

As you walk through this project and code along, you will go through the following steps, which align with the objectives:

• Step 1:Examine the database's structure and organize the tables.
• Step 2:Create the database.
• Step 3:Create the primary tables.
• Step 4:Create the related tables.
• Step 5:Finalize the script.

STEP 1: EXAMINE THE STRUCTURE

Before starting to build any database, you should go through the steps to normalize the structure and create an ERD or a list of tables ...