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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain the dml?
List out the components of logical database structure of oracle database.
how to make an oracle object
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain about achiever in sql?
How to display employee records who gets more salary than the average salary in the department?
What is recovery manager(rman) backup in Oracle?
How to create a new table in your schema?
What do you mean by merge in oracle?
What is max rowid in oracle?
How to do a full database export?
Why oracle is used?
How to start a new transaction in oracle?