Logical Design

Logical Design

Normalization

Normalization is the logical and methodical process which has definite rules and regulations and helps in arriving durable table arrangements. The whole process of normalization is largely dependent on the knowledge of data. The goals of normalizations include the elimination of redundant data. This includes saving data into more than one table. This also includes data dependencies that to store relevant data into the tables. These goals decrease the amount of database spaces and make sure that data is stored in a methodical way. There are several levels of normalization which include 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form), BCNF (Boyce-Codd Normal Form), 4NF (Fourth Normal Form), 5NF (Fifth Normal Form), DK/NF (Domain-Key Normal Form). BCNF is the sub form of 3NF and use in production database. 4NF, 5NF, and DK/NF are rarely used. These forms are used according to the conditions and when needed time to time. There are several advantages and disadvantages associated with normalization using all three forms.

Advantages

The advantages of normalization include the storage of data in the table as normalizing helps in large storage of data by making all its components easier. The similar pieces of information are stored in the other table which is relatively small than other tables. This is one of the biggest advantages of normalization as similar pieces can be found easily in a separate table. Normalization helps to reduce the redundancy rates in companies because it removes all the unwanted factors that do not fit for the workers according to the census of the company. This can also help in recruitment processes, that only skillful candidates can be interviewed at first choice, and it also ensures the company to have the best workers. These advantages help the human resource teams to update their databases for quick reviews. Normalization is also used in large company's databases, to handle immense amount of databases.

Disadvantages

Normalization has also some disadvantages such as it is not an easy task to apply formulae to store immense amount of data. It is also time consuming and not an easy task to input relevant formulas to get database functions properly. There is the requirement that personnel should be competent with computing in order to save time. It has more advantages than disadvantages when working in large companies. It requires large CPU, memory and Input and output process. It also requires a number of joins ...