Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization and types of normalization?
- 22 Answers
- 129314 Views
- Etisbew, F-TEC, Microsoft, TechProcess, I also Faced
- E-Mail Answers
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 the difference between rename and alias?
Is trigger a stored procedure?
Why is theta join required?
Can a trigger call a stored procedure?
How do I debug a stored procedure?
what is collation? : Sql dba
How to know the last executed procedure?
How to create an array in pl/sql?
What is the mutating table and constraining table?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How many types of literals are available in pl sql?
How do I save the results of sql query in a file?
Explain correlated query work?
What is a pl/sql block?
What is the main reason behind using an index?
