can any one explain about normalization forms with clear
explanation in interview point of view.
thanks for ur answers.
- 1 Answers
- 5437 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajeet khari
normalization is organizing data efficiently into database...
main thing is 1.elimination of redundant data,2. data
dependencies..
1NF-a table is decomposed into 2D table with no duplicate
column....
2nd NF- should be in 1NF and there should not be any
duplicate row...
3NF- should be in 2NF and contains transitive dependencies
remove that column which are not dependent on PK.
4NF-should be in 3NF and it has no malti valued dependencies.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the difference between data source and database?
What is difference between clustered, non-clustered and unique index?
How to produce such kind of file?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
What is the role of driver manager?
What will happen non-clustered index will be created on clustered index?
What is database schema name?
What is ole db ado?
Why do we need distributed database?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
Give the syntax of exception handling used in DBMS?
List the properties of a transaction.
what is the full procedure for using store procedure in informatica7.1?
What is relational database with example?
