Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization and its forms?
- 4 Answers
- 14480 Views
- Challenger Financial, I also Faced
- E-Mail Answers
Answer Posted / rohit
Database normalization, sometimes referred to as canonical
synthesis, is a technique for designing relational database
tables to minimize duplication of information and, in so
doing, to safeguard the database against certain types of
logical or structural problems, namely data anomalies. For
example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.
Higher degrees of normalization typically involve more
tables and create the need for a larger number of joins,
which can reduce performance. Accordingly, more highly
normalized tables are typically used in database
applications involving many isolated transactions (e.g. an
automated teller machine), while less normalized tables tend
to be used in database applications that need to map complex
relationships between data entities and data attributes
(e.g. a reporting application, or a full-text search
application).
Database theory describes a table's degree of normalization
in terms of normal forms of successively higher degrees of
strictness. A table in third normal form (3NF), for example,
is consequently in second normal form (2NF) as well; but the
reverse is not necessarily the case.
Although the normal forms are often defined informally in
terms of the characteristics of tables, rigorous definitions
of the normal forms are concerned with the characteristics
of mathematical constructs known as relations. Whenever
information is represented relationally, it is meaningful to
consider the extent to which the representation is normalized.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
How to find tables without indexes?
Does partitioning improve performance sql server?
Tell me what is difference between view and materialized view?
what is the system function to get the current user's user id? : Sql server database administration
Explain nested trigger in sql?
How to create user defined functions with parameters?
How you can get the list of largest tables in a database?
What area unit the various kinds of info compression introduced in sql server 2008?
How to Insert multiple rows with a single insert statement?
What are the rendering extensions of ssrs?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Do you know what is difference between index seek vs. Index scan?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is coalesce in sql server?
