Step 1: Read it

SQL for MySQL Developers: Read Chapter 27.

SQL for MySQL Developers: Skim Chapters 28, 29, and 30.

Read the Database Normalization PDF.

Database Normalization.pdf

Step 2: Do it

When the book has an example for trying out a SQL example, DO IT.

The chapters also have exercises which have answers at the end of each chapter, try these out as time permits.

Before doing Homework 6 try out the EER Diagram component of MySQL Workbench. Import the Tennis database into the EER Diagram window.

EER Diagram Modeling Tutorials

https://dev.mysql.com/doc/workbench/en/wb-tutorials.html

Step 3: Practice it

Homework 6 - Database normalization

Project 2 - Design and create a database