Normalization
Normalization Normalization is a database design technique which begins by examining the relationships (called functional dependencies) between attributes. Uses a series of tests (described as normal forms) to help identify the optimal grouping for these attributes to ultimately identify a set of suitable relations that supports the data requirements of the enterprise. The purpose of normalization is to identify a suitable set of relations that support the data requirements of an enterprise. The characteristics of a suitable set of relations include the following: Ø The minimal number of attributes necessary to support the data requirements of the enterprise. Ø Attributes with a close logical relationship Ø Minimal redundancy Normalization of purchase order system First find out attributes of the system Key as PO-NO List all the attribute in one relation add applicable values. First Normal Form - 1NF A r...