3. Database Design
Whenever you are working with a relational database management system such as MySQL, the first step in creating and using a database is to establish its structure. Database design, aka data modeling, is crucial for successful long-term management of your information. Using a process called normalization, you carefully eliminate redundancies and other problems that will undermine the integrity of your data.
The techniques you will learn in this chapter will help to ensure the viability, performance, and reliability of your databases. The example I will use—a record of business transactions such as invoices and expenses—will be referred to in later chapters, but the principles of normalization apply to any database you might ...
Get MySQL, Second Edition: Visual Quickstart Guide 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.
