Interested to Buy Any Domain ? << Click Here >> for more details...
wat is mean by normalization?......programing defination i
need...(i know basic defination)
- 4 Answers
- 8722 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / murtaza
normalization supports Atomicity which is one of d most impt
property in dbms.atomicity means there should be always one
record in a row.by this we can reduce the redundancy and
maintain consistency. as with this rule we go on normalizing
the tables depending upon the data dependency.
there r mainly 5 level of normalization
1.1NF(SUPPORTS ATOMICITY PROPERTY)
2.2NF(REDUCE REDUNDANCY)
3.3NF(FURTHER NORMALIZE D TABLES ACCORDING TO DATA DEPENDENCY)
4.BOYCE-CODD NF(SUPPORTS TRIVIAL DEPENDENCY)
5.5NF
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different types of replication you can set up in sql server?
Tell me what is the stuff and how does it differ from the replace function?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is the difference between the 2 operating modes of database mirroring?
How to view existing indexes on an given table using sys.indexes?
How do I shrink an ldf file?
How to Update from select query in sql server?
How to make remote connection in database?
How to select some specific rows from a table in ms sql server?
What are the types of ssrs?
What do you mean by collation recursive stored procedure?
What is difference between views and tables?
What is self contained scalar sub query?
What is the use of keyword with encryption. Create a store procedure with encryption?
How we create SQL Server 2005 Reporting Services ? Give me Sample
