What is normalization ?
Answers were Sorted based on User's Feedback
Answer / sohail
Normalization is a rule applied on the database table in
order to remove redundancy of data.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / lakshmi
Normalization is the process of breaking of data and
storing it into different tables to reduce the redundency
and to avoid nulls
Is This Answer Correct ? | 10 Yes | 0 No |
Normalization is the process of organizing the table to
remove redundancy.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / amruta
It is a step by step process to decompose or brake a large
table into smaller no of tables. To eliminate Insertion,
updating and deletion anomalies.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / abc
normalization is a process to remove data redundancy
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ganesh
Normalization is the process of splitting a table into
smaller units to avoid redundancy and reducing the retrieval
time of a data. Let consider if your table having more than
one million records. Now you want to pick up the name or
data of a particular person in a table. It will take much
time to display the data. To overcome this drawback we user
normalization.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / dhivya
Normalization is a process of designing a database in which
the redundancy is avoided. It includes several Normal forms
namely 1NF, 2NF, 3NF, BCNF, 5NF etc...
Is This Answer Correct ? | 3 Yes | 0 No |
It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,
-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.
Is This Answer Correct ? | 1 Yes | 0 No |
how to use case expression? : Sql dba
difference between SQL and C
1 Answers Indus Software Technologies,
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
What is sql stand for?
What is a common use of group by in sql?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
What do you understand by case manipulation functions?
how many triggers are allowed in mysql table? : Sql dba
What is the use of procedures?
What do you mean by dbms? What are its different types?
can i use dbms_output.put_line in a function u are telling as return statement
If a View on a single base table is manipulated will the changes be reflected on the base table?