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 a cube? : sql server analysis services, ssas
What is raiseerror? What is raiseerror?
What is row by row processing ?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
When a primary key constraint is included in a table, what other constraints does this imply?
What are the aggregate and scalar functions?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
What is BCNF? How is it better than 2NF & 3NF?
what is DTS what are tasks available
What are wait types?
Explain the cursor lock types?
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)