From the course: Learning phpMyAdmin
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Normalizing a table
- To make a database efficient and easy to maintain, data needs to be organized logically in tables, eliminating redundant information wherever possible. Normalization is a common technique that can be used to achieve this, and if you're using PHPMyAdmin 4.3 or later, there's an interactive tool to help with this process. So let's try this out on the cars table in the up-and-running database. Select the table, and then hit Structure tab, and you access the interactive tool by clicking "Improve Table Structure" down at the bottom here. And it begins by asking you to choose the level of normalization: 1NF, 1NF + 2NF or 1NF + 2NF + 3NF. So what does this all mean? The First Normal Form, or 1NF, requires the following: each field in the table must be atomic, in other words, it can't be broken down into smaller units. For example, a field for a person's name could be broken down into Title, First Name, Middle Name or Initial, and Family Name. It might even be necessary to have a separate…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.