Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization and types of normalization?
- 22 Answers
- 129979 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 are the authentication modes in sql server? How can it be changed? : Sql dba
What is int identity in sql?
What is the difference between database trigger and stored procedure?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Which query operators in sql is used for pattern matching?
What are its different types of dbms?
What is delimiter in pl sql?
Can we call a function containing dml statements in a select query?
When you have to use a default "rollback to" savepoint of plvlog?
explain primary keys and auto increment fields in mysql : sql dba
What is dml and ddl?
Why do we need databases?
Why do we use cursors?
How to select unique records from a table?
What is information schema in sql?
