What is normalization and types of normalization?
Answers were Sorted based on User's Feedback
Answer / subitha
Normalization is a systematic way to ensure that a
database structure is suitable for general purpose qureying
and free from certain undesirable character that lead to
loss of data integrity.
Is This Answer Correct ? | 10 Yes | 4 No |
Answer / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada and the answer
is mentioned below
Normalization: The focus of normalization is to help data
base designers to design the table structures for an
application. It helps to reduce rebundant table data to the
very minimum. Main use is to improve the performance of
DBMS.
First normal form: There must be no any duplicate
records & repeating groups.
Second normal form: Remove subsets of data and place
in a separate table.
Third normal form: Remove columns that are not
dependent on primary key
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / srabani das
The basic facts of normalization is to reduced redundancy
which means that information stored only once.storing the
information in several times leads to lost of storage space
and increase in total size of data base.Relation are
normalized so that when relation of database are to be alter
during the life time of the data base. we do not lost
information.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / jasmine
Normalization is a process of designing the table(relation)
with the reduced redundancy and making clear whether the
attributes in a table is depend on the primary key or
dependencies make sense(ie:storing only the related datas
ito the table). This is achieved by normal forms.
Basic types of normal forms are,
1NF-first normal form(Eliminates duplicate or
repeating values)
2NF-second normal form(Eliminates redundant datas in
one or more tables)
3NF-Third normal form(Removing the columns that are
not truely depending on the primary key)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dileep
standardization: the imposition of standards or
regulations; "a committee was appointed to recommend
terminological standardization...
1st NF
2nd NF
3rd NF
4th NF
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s.munna
Normalisation is basically avoid redundent data in database
for saving memory space and faster manipulation of data
keep and insert ,update , delete anamollies.....
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / r.arjunarao
Normalization means reduces redundancy unnecessary
repetition of data is NF
UnNormalization means intentional introduction redundancy to
a table to improve the performance is De-NF or Un-NF
1NF Any multiple values Attribute have been removed.
2NF Any partial functionality dependency have been removed.
3NF Any transitive functionality dependency have been removed.
4NF Any multi-values dependency have been removed.
5NF Any remaing anomalies have been removed.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / tumaini katobe
Is the process of assigning attributies to entities or is
the technique of designiing database with the least
redunducy and duplicancy of data.
There are five types of normalization, these are:
First Normal form
Second Normal form
Third Normal form
Fourth Normal form
Firth fourth form
Is This Answer Correct ? | 7 Yes | 7 No |
Answer / prasad
it is nothing but reduce reduancy for data storge and to
make data more simple
Is This Answer Correct ? | 3 Yes | 4 No |
What is the difference between pl and sql?
If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?
What is data profiling in sql?
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Explain ddl statements in pl/sql?
What is function and procedure in pl sql?
What is union and union all keyword in sql?
what is the difference between stored procedure and packaged procedure
Why is sql*loader direct path so fast?
Why left join is used in sql?
how to create a primary key with out creating an index?