Job Ready SQL

Lesson 4Pulling It All Together: Normalizing a Vinyl Record Shop Database

As a beginning developer, you are not likely to have to normalize large databases right off the bat. Most businesses that maintain their own databases also have a team of database specialists who handle things like that. However, you are likely to have to access data stored in a database, which means that you do need to understand how a database is structured.

In this lesson, you will use everything you've learned up to this point to pull together a database and normalize it as well as create an entity‐relationship diagram (ERD) to model the database.

Learning Objectives

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

• Determine the fields for a database
• Identify the appropriate data type for each field
• Normalize the data to third normal form
• Create an ERD for the database

NOTE Throughout this book are several lessons that help you pull together all the things you've learned in the previous chapters. These lessons take a different format that is more hands‐on than others. As you work through this lesson, you should be working through the solution. Because the lessons that pull it all together are more hands‐on, they will not include additional exercises.

THE VINYL RECORD SHOP DATA OVERVIEW

To pull together everything you've learned to this point, in this lesson, you will create and work with a relatively small inventory database for a vinyl music store that sells both singles and full albums. ...