Summary

In today's lesson, you learned how to start creating a new database by looking at the design process.

You saw the importance of analyzing the business needs in terms of business processes, business objects, and the rules that bind them together. Taken together, these things form an outline of your database design in terms of tables and applications.

We paid particular attention to database table design, and you learned about normalizing data to make it truly relational.

This has been a relatively non-MySQL specific lesson, but in the days that follow, you will see how these fundamental principles are implemented in a MySQL environment.