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.
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
