Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition

3. Data Modeling and Normalization

Data modeling is the process of analyzing the things of interest to your organization and how these things are related to each other. The data modeling process results in the discovery and documentation of the data resources of your business. Data modeling asks the question “What?” instead of the more common data-processing question “How?”

Data modeling asks the question “What?”

Before implementing databases of any sort, a DBA needs to develop a sound model of the data to be stored. Novice database developers frequently begin with the quick-and-dirty approach to database implementation. They approach database design from a programming perspective. Because novices often lack experience with databases and data ...