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 |
Which databases are part of SQL server default installation? Explain the usage of each?
How many database files are there in sql server 2000?what are they?
What is optimistic concurrency?
What is the sql server agent?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is the Difference beween sql server 2005 and sql server 2008
What does man by sql wildcard characters in sql server?
How to connect sql server management studio express to sql server 2005 express?
Explain what is public role in sql server?
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
What are the benefits of filtered indexes?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)