What is normalization?
Answers were Sorted based on User's Feedback
Answer / anjana
Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data (for example, storing
the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ghous
well normalization is a broader concept and couldbe called
the back bone of RDBMS..
it involves multiple steps and levels ranginf grom 1-5
that removes dependencies repetition etc...
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raj
It is the process of deciding which attributed has to
grouped to avoid data redundancy.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jerry joseph
Normalization is the process of removing redundant data and
preventing anomalies during database updates.
we have 1st degree, 2nd degree 3rd degree etc..
3rd degree normalization is commonly used.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jai
It is the process of desiging narrow tables from the
collection of data to avoid repition of data
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / guest
Well a relational database is basically composed of tables
that contain related data. So the Process of organizing this
data into tables is actually referred to as normalization.
| Is This Answer Correct ? | 1 Yes | 1 No |
normalization is a design process for representing data in
tabular format.the five normal forms are progressive rules
to represent the data with minial redundancy
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ricky
relational database is composed of related data. so method
to combine these table together is known as normalisation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / maheswar reddy s
Normalization is database scheema design technique.by which an existing database modified to minimize the redundency and dependency of data
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the differences between sql server and mysql.
can we call functions from stored procedure in SQL Server 2005 ? How?
Can XML be used to access data?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is clr ddl trigger?
What is storeprocedure?Tell me synatx for how to write stored procedure.
How to disable triggers using "disable trigger"?
What are functions in the sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is de-normalization and what are some of the examples of it?
How to delete duplicate rows?
What is the difference between truncate and delete commands?
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)