Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization ?
- 9 Answers
- 22491 Views
- BirlaSoft, CTS, HCL, I also Faced
- E-Mail Answers
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 |
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
what are the demerits of sql?
Can we alter stored procedure?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
What steps server process has to take to execute an update statement?
What is a loop in sql?
Which operator is used in query for pattern matching?
what are string data types? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
What is relationship? How many types of relationship are there?
What is difference between % ROWTYPE and TYPE RECORD ?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
