Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition
by Michael J. Hernandez
Understanding Normalization
A solid database structure is the foundation of any successful database application, and you will inevitably encounter problems if your database is poorly designed. Regardless of how you access your data, the information you retrieve is only as good as the data upon which it is based. In this paper, I’ll cover a traditional database design topic that seems to be quite a hurdle for many database designers and developers: Normalization. Normalization is the process of refining table structures into a proper state so that they can store data as efficiently as possible. Here you'll discover why Normalization is crucial and learn how to normalize your tables using Normal Forms. First, you'll learn about modification ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access