What is normalization in Database ?

Answer Posted / muralidharan

Normalization was introduced in RDBMS by IBM, and the use
of normalization is to check the database consistency of a
table.There are three types of normalization forms
1 First normalization
2.second normalization
3. third normalization

Murlaidharan
dharanmu@yahoo.com

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between stored procedure and user defined function?

724


What is the difference between writing data to mirrored drives versus raid5 drives

688


What is lock escalation? : sql server database administration

800


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1071


How to test a dml trigger in ms sql server?

755






Do you know what is a trace frag? Where do we use it?

716


How global temporary tables are represented and its scope?

716


How to connect sql server management studio express to sql server 2005 express?

747


What is mean by candidate key?

747


What is cursors?

804


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

779


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.

2671


What are “lock” hints?

757


What is star, snowflake and star flake schema? : sql server analysis services, ssas

854


How many types of cursor type are there?

753