Discuss the three goals of normalization.
What will be an ideal response?
Normalization has three goals. First, normalization reduces the space required to store data by eliminating duplicate data in the database (with the exception of duplicate data in the foreign key fields). Second, normalization reduces inconsistent data in the database by storing data only once, thereby reducing the chance of typographical, spelling, and transposition errors and other inconsistent data possible in flat file databases. Finally, normalization reduces the chance of deletion, update, and insertion anomalies.
You might also like to view...
The ________________ reference always refers to the currently executing object.
a) null b) static c) final d) actual e) this
Which of the following states the Rule of Entity Integrity?
a. Every row must have a value for the primary key and each value must be unique. b. Every foreign key must appear as another table’s primary key. c. Every row must have a value for the primary key and values may be repeated. d. None of the above.
Give two reasons why RAID cannot replace backups.
What will be an ideal response?
Cellular phones offer tracking capabilities because they can determine their geographic location using either mobile locating or ____ technology.
A. radio B. cellular C. GPS D. RFID