In this video tutorial I explain how to create efficient tables using SQL. Specifically I’ll show you how to create Atomic Databases. A table is considered Atomic when it focuses on describing just one thing. Here is an article that goes more into this subject MySQL Atomic Tables.
Once you make all of your tables you should make sure they are Normalized. A Normalized Table is a table that follows the 3 Normalized table rules.
First Rule of Normalized Tables
Second Rule of Normalized Tables
Third Rule of Normalized Tables
All of this information is demonstrated in the following video and if you want to read more on the subject see the following Complete SQL Statements Video Tutorial.