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 are the benefits of stored procedures?
How bulk collect improves performance?
Explain the uses of a database trigger?
What does select top 1 do in sql?
What is pl sql quora?
How do you write a complex sql query?
What are the types of variables use in pl sql?
What does a pl/sql package consist of?
Does view contain data?
What is keys and its types?
What is pl/sql table? Why it is used?
What do you mean by rowid?
How many functions are there in sql?
How sql query is executed?
What do you mean by field in sql?