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
- 8707 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 |
how many joins we can write if at all we have n no of tables
5 Answers Tanla Solutions, TS,
What is the sql case statement used for?
What is difference between unique and primary key?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is hot add cpu in sql server 2008?
What is the command to change the recovery model?
How to insert a new row into a table with "insert into" statements in ms sql server?
Which are the third-party tools used in sql server and why would you use them?
How global temporary tables are represented and its scope?
What are the differences between triggers and stored procedures?
What is the difference between Procedure and Function
4 Answers Accenture, Nagarro, TCS,
why would you use sql agent? : Sql server database administration
-
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)
