Interested to Buy Any Domain ? << Click Here >> for more details...
what is Normalization means..?
- 8 Answers
- 32176 Views
- AZTEC, Bank Of America, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / firoz basha
Normalization is a series of steps followed to obtain a
database design that allows for consistent storage and
efficient acess of data in a relational database.
These steps reduce data redundancy and risk of data
becoming inconsistent.
there are 5 types of normal forms(NF) :
1 NF , 2NF, 3NF, 4NF, 5NF
1NF:- A relation is said to be in first normal form , if it
dows not contain any repeating groups or elements (or) if
all the values are atomic
2 NF:- A relation is said to be in Second Normal form, if
and only if it is in 1 NF and all the non-key attributes
are fully functionally dependent on the primary key.
3 NF:- A relation is said to be in 3rd normal form, if and
only if it is in 2NF and every non-key attribute is
non-transitively dependent on the primary key.
(or) every attribute is independent of all the other non-
key attributes.
BCNF:- A relation is said to be in BCNF, if every attribute
on which some other attribute is also a candidate for
primary key of a relation.
4 NF:- A relation is said to be in 4th normal form, if and
only if it is in 3NF and it should not contain any
multivalued dependencies.
5 NF :-A relation is said to be in 5 NF , if and only it it
is in 4 NF and every join dependency in R is implied by the
candidate key.
Any clarifications and for examples,
mail me : firozbashashaik@yahoo.com
| Is This Answer Correct ? | 44 Yes | 4 No |
Post New Answer View All Answers
How to do Data integrity testing? Who does this testing (Developer or tester)?
What are the advantages of normalizing a database.
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What are the most common databases?
List some advantages of dbms.
How do I manually create a database?
What are the advantages of views in a database?
How many indexes can be created on a table?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
A design problem was given in which I was supposed to make a design for the data base for a given problem.
Explain normalization in one line?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What is relational database with example?
What do you mean by foreign key and primary key?
What does new grouping sets enables you to do?
