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
Explain the commit statement.
Do foreign keys improve performance?
What is a natural join?
How do you know if a relationship is 2nf?
What is the difference between a query and a report?
What is a pdo connection?
What are string functions in sql?
How can we store rows in PL/SQL using array?
What is varchar sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How many types of tables are there?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is parallel hint?
Is sql procedural language?
Does sql profiler affect performance?