Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization and types of normalization?
- 22 Answers
- 128463 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 a system versioned table?
what is the difference between char and varchar data types? : Sql dba
What is difference between table and view?
What is the difference between row level and statement level trigger?
What is a full join sql?
Is subquery faster than join?
how to check myisam tables for errors? : Sql dba
What is before and after trigger?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
difference between anonymous blocks and sub-programs.
What are inner outer left and right joins in sql?
What is the use of partition by in sql?
Explain the types of joins in sql?
What is primary and foreign key?
What does bitemporal mean?
