Normalization and Related Problems

 

 

 

Explain when is it necessary to apply the normalization process to a table.

Describe the problems that unnormalized tables would have so the database designer should be concerned and fix them.

 

Sample Solution

Normalization and Related Problem

Normalization should be part of the database design process. Normalization is the branch of relational theory that provides design insights. It is the process of determining how much redundancy exists in a table. The goals of normalization are to be able to characterize the level of redundancy in a relational schema and to provide mechanisms for transforming schemas in order to remove redundancy. Normalization is useful when your data has varying scales and the algorithm you are using does not make assumptions about the distribution of your data, such as k-nearest neighbors and artificial neural networks. Standardization assumes that your data has a Gaussian (bell curve) distribution.

dditionally, the second important festivals celebrate by Malay ethnic is Hari Raya Haji. They believe that it is an important day for Muslims to commemorate Ibrahim for following Allah’s command to sacrifice Ishmael (Ibrahim’s son). It is known as the Festival of Sacrifice, all Muslims observed the process. Allah stopped Ibrahim when he was about to sacrifice his son, and Allah told him that it was just a test to know whether Ibrahim can follow Allah’s command to sacrifice his son. Therefore, all Muslims will sacrifice animals with four-legged during Hari Raya Haji. They usually kill goats, cows or lamb in this sacrifice event. Then, the meat will be distributed to 3 parts which are for family, relatives or friends and last will be distributed to poor people. However, they believe that Ibrahim and his son Ishmael were guided by Allah to build ‘Kaaba’ the square tone building in a place name Mecca. Thus, that is the direction that all Muslims prayers pray towards all over the world. (Nurul Azliah Aripin, 2015)

VALUE & BELIEF

A value is the belief that people think it is preferable. It is something that people taught us and we believe it and follow the tradition set by ancestor. So, these cultures have been taught from one generation to next the generation until today. Besides that, different culture has their own values and basic belief.

In Malaysia, Chinese ethnic and Malay ethnic learn their value and belief of own culture. This is known as Enculturation and of course different culture has different belief. For Malay culture, they are known as Muslim prayers. All of the Muslim prayers pray to their god – Allah. For Muslim prayers, they strongly believe Allah is the universe creditor. Allah is also the meaning of God in the Arab language and they only believe Allah is the only God in Islam. Besides that, Muslim prayers used to pray to Allah 5 times a day is because they believe they can get some benefits by doing so. Muslim prayers can pray anywhere, but it will be better if there is a Mosque for them. For example, Muslim prayers will gather in Mosque every Friday and pray the Al-Quran. (BBC, 2014)

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.