What is normalization in Database ?
Answers were Sorted based on User's Feedback
Normalization was introduced in RDBMS by IBM, and the use
of normalization is to check the database consistency of a
table.There are three types of normalization forms
1 First normalization
2.second normalization
3. third normalization
Murlaidharan
dharanmu@yahoo.com
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / hari
Normalization is the process of designing a datamodel and
effociently store the data in a database. to reduce the
redundecny.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / nivedita
Normalization is the process of designing a datamodel and
effociently store the data in a databaseFirst normal form
(1NF) lays the groundwork for an organised database design:
Ensure that each table has a primary key: minimal set of
attributes which can uniquely identify a record.
Eliminate repeating groups (categories of data which would
seem to be required a different number of times on
different records) by defining keyed and non-keyed
attributes appropriately.
Atomicity: Each attribute must contain a single value, not
a set of values.
'First normal form' depends on functional dependency
formula f(x)=y. For every value of x there is value for y.
Second normal form
Second normal form (2NF) If a table has a composite key,
all attributes must be related to the whole key:
The database must meet all the requirements of the first
normal form.
The relational schema should not have any partial
functional dependency i.e. No proper subset of the primary
key should derive a functional dependency belonging to the
same schema. For example, consider functional dependencies
FD:{AB->C, A->D, C->D} here AB is the primary key, as A->D
this relational schema is not in 2NF.
Third normal form
Third normal form (3NF) requires that data stored in a
table be dependent only on the primary key, and not on any
other field in the table.
The database must meet all the requirements of the first
and second normal form.
All fields must be directly dependent on the primary key
field. Any field which is dependent on a non-key field
which is in turn dependent on the Primary Key (ie a
transitive dependency) is moved out to a separate database
table.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jerry joseph
Normalization is the process of removing redundant data and
avoiding anomalies due to updates and delete.
Is This Answer Correct ? | 5 Yes | 3 No |
List out the differences between global and local temp tables in sql server?
How to end a stored procedure properly in ms sql server?
Which one is faster delete/truncate? Why?
Distinguish between nested subquery and correlated subquery?
How to make remote connection in database?
What is a system database and what is a user database?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
What is named calculation? : sql server analysis services, ssas
Psudo colums
What is dataset and its uses
Is foreign key unique?
What are the requirements on sql server network connections?