wat is mean by normalization?......programing defination i
need...(i know basic defination)
Answers were Sorted based on User's Feedback
Answer / abhijeet chatterji
Normlization is the process with which we can reduce the
redundancy.
Is This Answer Correct ? | 11 Yes | 0 No |
Normalisation is to remove the redundancy.
Splitting into smaller oes without effect any data.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / shilpa
in normalization process ,the redundancy is reduce.there r
3 types of normalization
Is This Answer Correct ? | 0 Yes | 6 No |
What is the difference between a function and a trigger?
Explain the concept of recursive stored procedure.
what authentication modes does sql server support? : Sql server database administration
Explain acid?
What extended events?
How to access the deleted record of an event?
how you can get the list of largest tables in a database? : Sql server administration
How many types of Outer Joins?What are they?
UPDATE statement can on a single table or on the multiple table?
What are the Pre Requisites when you apply Srvice Packs?
Explain an incremental backup?
Wht is SQL Injection Attack ?