what is Normalization means..?
Answer Posted / amresh
In simple words process of replacing a relation with more
than one relation so as to come round with problems of bad
database design(i.e redundancy,insertion,updation,deletion
anomalies_---
The three primitive normal forms r
1> 1-nf:asserts that relation with
atomic values.
2> 2-nf:asserts with eliminating partial
dependency.
3> 3-nf:asserts at eliminating
transitive dependency.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
How many indexes can be created on a table?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
Explain buffer manager?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
After normalization, what are the conditions which have to keep in mind to de-normalize it?
define primary key index, bitmap index, hash index,virtual indwx
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
What is difference between data and database?
what is the full procedure for using store procedure in informatica7.1?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
What are the most common databases?
What is Data Modelling?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.