What is normalization and types of normalization?
Answer Posted / 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 |
Post New Answer View All Answers
What is minus?
how can we destroy the cookie? : Sql dba
What is column?
define data blocks ? : Sql dba
how to select first 5 records from a table? : Sql dba
How do I run a script in sql developer?
What is procedure explain with program?
What is pls_integer in pl sql?
describe transaction-safe table types in mysql : sql dba
Is sql workbench free?
What is a system versioned table?
what is try_catch block in procedure
Whis is not false in primary key?
Why do we need a foreign key?
What are local and global variables and their differences?