Explain 1st, 2nd, 3rd normalization form of data base
Answer Posted / padma
1st normal form: first identify the repeating group of
fields n group them into separate table
2nd normal: it should be in 1st normal form and check all
fields are dependent on primary key
3nd normal form: it should be in 2nd normal form and check
all the fields r independent of any other non-key attribute
ie removes the fields that dependent on non-key
1st normal: first identify repeating fields and group them
another table
2nd normal: it should be in 1st normal form and identify
that all fields all dependent on primary key.
3nd normal: it should be in 2nd normal form and check all
fields all indpendent of other non-key attribute
| Is This Answer Correct ? | 49 Yes | 5 No |
Post New Answer View All Answers
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is the usage of control file in oracle?
How to use "out" parameter properly?
How do you bind variables in oracle?
What are the arithmetic operations?
Can we create trigger on materialized view in oracle?
Give the various rollback segment states.
What is the difference between translate and replace in oracle?
How to drop an index?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the difference between hot backup and cold backup in oracle?
What happens to the current transaction if the session is killed?
What are the original export and import utilities?
What suggestions do you have to reduce the network traffic?
What are the types of partitions in oracle?