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.