Explain the essence of normalization that is implemented through the use of normal forms
What will be an ideal response?
The essence of normalization is to create relations that contain data on a single theme, and for each row in a relation to contain all the data about that theme for a given entity. This essence is implemented in the normal forms by taking a relation that contains data on more than one theme and splitting it into multiple relations that each contains data on a single theme. The different normal forms protect against the occurrence of modification anomalies. In practice, making sure all relations are in Boyce-Codd Normal Form (BCNF), or in Fourth Normal Form (4NF) if multivalued dependencies are found, insures high reliability of the database.
You might also like to view...
What type of a scale asks the respondent to state his/her agreement or disagreement with a series of statements about a specific brand in terms of a five-point scale ranging from strongly agree to strongly disagree?
a. Likert scale b. Semantic differential scale c. Paired-comparison scale d. Constant sum scale e. Numerical scale
The Hurwicz criterion:
A) multiplies the worst payoff by one minus the coefficient of optimism. B) multiplies the best payoff by one minus the coefficient of optimism. C) is a compromise between the minimax and maximin criteria. D) all of the above