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, 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...
The ________ error message displays when a referenced cell contains the wrong type of data
A) #NUM! B) #VALUE! C) #DIV/0! D) #REF!
Match the following parts of an Access window to their descriptions:
I. Navigation Pane II. Ribbon II. title bar IV. Field Properties pane V. Backstage view A. provides access to database tools such as Save, Save As, and Print B. contains details of each field C. displays full path name and file name D. area that organizes and lists database objects E. includes five tabs
In Outlook Express, the ________ folder stores messages that you have deleted
A) Recycle Bin B) Outbox C) Deleted Items D) Empty
In the Outline tab, text is arranged as in an ordinary outline. Slide ____ are the top levels in the outline, and the slide content-that is, the bulleted lists-are indented below the slide titles.
A. properties B. sections C. titles D. headers