Describe the purpose of normalizing data and identify the four most commonly used normal forms.
What will be an ideal response?
The normalization process, as first proposed by Codd (1972a), takes a relational schema through a
series of tests to assess whether or not it belongs to a certain normal form. Normalizing data is the
process during which unsatisfactory relational schemas are decomposed by breaking up their
attributes into smaller relational schemas that possess desirable properties.
Codd proposed three normal forms called first, second and third normal forms. A stronger
definition of the third normal form was proposed later by Boyce–Codd normal form (BCNF). All
of these normal forms are based on the functional dependencies among the attributes of a relation.
You might also like to view...
C:\Windows\System32\drivers\etc\protocol is an example of a file ________
A) list B) type C) path D) extension
Match the following terms to their meanings:
I. Denotes the amount of CPU capability that is not A. CPU Time being used II. Collection of tools with which you can perform B. network interface card tasks such as configuring hard disks III. Measures how long it takes for a processor to C. System Idle Process complete a task IV. Enables your computer to communicate with D. Resource Overview a network V. CPU usage, hard disk drive usage, network usage, E. Computer Management and memory usage instantaneous readouts
Currently, more than ____ percent of Internet users access the Web with a W3C-compliant browser.
A. 65 B. 80 C. 90 D. 95
J2EE is a good example of industry standard.
Answer the following statement true (T) or false (F)