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.

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...

Answer / raj

It is the process of deciding which attributed has to
grouped to avoid data redundancy.

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.

Answer / jai

It is the process of desiging narrow tables from the
collection of data to avoid repition of data

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.

Answer / suhail qaiser

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

Answer / ricky

relational database is composed of related data. so method
to combine these table together is known as normalisation.

Answer / maheswar reddy s

Normalization is database scheema design technique.by which an existing database modified to minimize the redundency and dependency of data

List some major differences between triggers and stored procedures?

0 Answers  

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

Which is the best place or learning center for MS SQL?????In Bangladesh?????

0 Answers   TCL, Wipro,

What is clustered vs nonclustered index?

0 Answers  

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

What is a job?

3 Answers  

Explain the rules for designing files and file groups in sql server?

0 Answers  

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

How can we determine what objects a user-defined function depends upon?

0 Answers  

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,