NORMALIZATION OVERVIEW As we continue with the process of logical database design, we will start with the data structures created. At this time there are no more entities and relationships--only the design for the relational tables exists. Before we sit down to implement our database, there is one more step we need to complete. This step is called Normalization. Normalization will provide a final check on the validity of our data structures before we began the implementation process. Our goal is to reduce data redundancy that causes problems called anomalies . . Anomalies occur when we incorrectly combine attributes into relations and can cause serious problems later when we try to maintain and use our data. The normalization process consists of performing a series of tests on our data structures to verify that our
This is the end of the preview.
access the rest of the document.