wht is normalization?can u explain me in detail?
Answers were Sorted based on User's Feedback
Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / nesa4180
The process of separating data into distinct, unique sets
is called normalization.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / koti
It is the process of removing redundancy data by splitting
the the tables into smaller tables in order to improve the
performance of the data retrieval.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / granto
The process
of deciding what tables to create and what relationships
exist between them is known as
normalisation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
Normalisation is when you reduce redundancy of data in
tables & increase performance
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / md.abdul azeez
Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense
0 Ramesh L.v.
Re: wht is normalization?can u explain me in detail?
Answer
# 2 Normalisation is when you reduce redundancy of data in
tables & increase performance
0 Guest
Re: wht is normalization?can u explain me in detail?
Answer
# 3 The process of separating data into distinct, unique
sets
is called normalization.
3 Nesa4180
Re: wht is normalization?can u explain me in detail?
Answer
# 4 It is the process of removing redundancy data by
splitting
the the tables into smaller tables in order to improve the
performance of the data retrieval.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / anil rajwadi
the task for database design is to structure in way that
eliminated unnecessary duptication and provide rapId path
search to all necessary information.the process of refining
table,column,key and relationship to create efficent
database is call normalization
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shiva
Normalisation is the bottom up approach to design the database.Normalisation is the process of organising data in a table to reduce reduncy and to improve performance.Normalisation is a set of rules and each rule is called one normalform.
| Is This Answer Correct ? | 0 Yes | 0 No |
Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key
| Is This Answer Correct ? | 0 Yes | 5 No |
What all db objects can be found in MSDB database of a SQL Server instance?
How efficient you are in oracle and SQL server?
What are the disadvantages of indexes?
how can i view structure of table in sql server? tell me that query.
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is hot add cpu in sql server 2008?
Can some one please help with a query which will take only max value of a column in a join.
What causes index fragmentation?
What is an index in a database?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is left outer join in sql server joins?
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
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)