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
- 8660 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
How to enter binary string literals in ms sql server?
Define cursor locking
What is the difference between TRUNCATE and DROP?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
what is the difference between delete table and truncate table commands? : Sql server database administration
explain how to create a new schema in a database? : Sql server database administration
What is a transact-sql statement?
what are the three command line utilities and what are their primary functions?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What are the types of processing and explain each? : sql server analysis services, ssas
How do I manually uninstall an instance of sql server 2016?
Do you know what is user defined datatypes and when you should go for them?
Explain what is lock escalation?
Can you explain various data region available in ssrs with their use?
What should be the fill factor for indexes created on tables? : sql server database administration
