Describe the purpose of normalizing data.
What will be an ideal response?
The purpose of normalization is to identify a suitable set of relations that support the data
requirements of an enterprise. The characteristics of a suitable set of relations include the
following:
? the minimal number of attributes necessary to support the data requirements of the enterprise;
? attributes with a close logical relationship (described as functional dependency) are found in
the same relation;
? minimal redundancy with each attribute represented only once with the important exception of
attributes that form all or part of foreign keys (see Section 4.2.5), which are essential for the
joining of related relations.
The benefit of using a database that has a suitable set of relations is that the database will be
easier for the user to access and maintain the data, and take up minimal storage space on the
computer.
You might also like to view...
Which of the following is true about infrared transmissions?
A. directed IR transmission relies on reflected light B. diffused IR transmission requires emitter and detector to be aligned C. the intensity of the light pulse indicates the on or off status of each bit D. IR transmissions have speeds up to 25 Mbps.
You suspect that there are a number of deleted files that can still be salvaged in the unallocated space of a drive image. During which phase of the investigation would you use a data carving utility?
a. Examination b. Acquisition c. Identification/Assessment d. Analysis e. Reporting
A meeting ____ is an e-mail invitation to the meeting.
A. notification B. message C. request D. invite
import java.util.*; public class sortArray { public static void main(String[] args) { double[] lengths = {120.0, 0.5, 0.0, 999.0, 77.3}; Arrays.sort(lengths); System.out.println(Arrays.toString(lengths)); } } ? Using the above code, what will be the output of the println statement when the code is executed?
What will be an ideal response?