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
- 8501 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Explain activity monitors
What is the difference between stored procedure and user defined functions?
How can i change the column name.
13 Answers HCL, Yardi Software,
What are commonly used odbc functions in php?
What is the use of DBCC commands?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How to select true false based on column value in sql server?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is the function of sql server agent windows service?
What is the primary use of the model database?
-
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)
