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 sql dialect?
How many types of literals are available in pl sql?
What are triggers and its uses?
Can a table contain multiple foreign key’s?
Can a primary key be a foreign key?
How to call shell script from pl sql procedure?
How do I view stored procedures?
what is 'mysqlshow'? : Sql dba
Does inner join return duplicate rows?
What are pl/sql packages?
How can you load multi line records? : aql loader
What are sql*plus environment variables?
How do you determine the current isolation level? : Transact sql
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is basic structure of pl sql?