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
What is a trigger oracle?
What is an oracle recycle bin?
How are extents allocated to a segment?
What is the Tune Query
How to save query output to a local file?
What is the fastest query method to fetch data from the table?
Which are the five query types available in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What is the parameter mode that can be passed to a procedure?
Explain do view contain data?
How to start your 10g xe server from command line?
What are triggers in oracle?
Design database draw er diagram for a certain scenario ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is oracle sid?