What is normalization and types of normalization?
- 22 Answers
- 124095 Views
- Etisbew, F-TEC, Microsoft, TechProcess, I also Faced
- E-Mail Answers
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
how to convert character strings to numeric values? : Sql dba
Which join is like an inner join?
What is the sql*loader? : aql loader
What is the source code of a program?
how to run 'mysql' commands from a batch file? : Sql dba
Show the cursor attributes of pl/sql.
What is difference between left and right outer join?
What is embedded sql what are its advantages?
Is sql microsoft?
how to present a past time in hours, minutes and seconds? : Sql dba
What is sql in oracle?
What if we write return in procedure?
What is the difference between partitioning and sharding?
what is bcp? When is it used?
Does sql between include endpoints?
