Discuss how the technique of normalization can be used to validate the relations derived from the conceptual data model.

What will be an ideal response?


The logical data model can be validated using the technique of nomalization and against the
transactions that the model is required to support. Normalization is used to improve the model
so that it satisfies various constraints that avoid unnecessary duplication of data.
Normalization ensures that the resultant model is a closer model of the enterprise that it serves,
it is consistent, and has minimal redundancy and maximum stability.

Computer Science & Information Technology

You might also like to view...

Which of the following are correct?

a. A constructor must be declared for each class. b. A constructor must be declared with a return type c. A default constructor can only be provided by the compiler. d. A class can have only one default constructor. e. A class can have only one constructor.

Computer Science & Information Technology

A color ____________________ holds the selection of colors and allows you to select a group of colors to use for a bitmap graphic.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Suggest a design for a filter that would distinguish queries revealing sensitive data about the inquirer from those that do not reveal anything. What qualities might indicate that a query was sensitive?

What will be an ideal response?

Computer Science & Information Technology

What type of OS manages hardware and software on a client computer?

A. network OS B. client OS C. workstation OS D. appliance OS

Computer Science & Information Technology