What is normalization and types of normalization?
Answer Posted / 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 |
Post New Answer View All Answers
What is graph sql?
What is exit statement?
What is an intersect?
What is the use of index in hive?
What is the reports view in oracle sql developer?
Is inner join faster than left join?
How to connect a sql*plus session to an oracle server?
What is sqlca in powerbuilder?
Does truncate release storage space?
tell us something about heap tables. : Sql dba
What will you get by the cursor attribute sql%found?
Should I use mbr or gpt?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is memory optimized?
What are the different types of dbms?