Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22360 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / mohan.s
Second normal form (2NF) If a table has a composite key,
all attributes must be related to the whole key:
• The database must meet all the requirements of the
first normal form.
• The relational schema should not have any partial
functional dependency i.e. No proper subset of the primary
key should derive a functional dependency belonging to the
same schema. For example, consider functional dependencies
FD:{AB->C, A->D, C->D} here AB is the primary key, as A->D
this relational schema is not in 2NF.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
What are db2 objects?
What is runstats and reorg in db2?
What is a db2 package?
What is db2 plan table?
What is reorg and runstats in db2?
How does db2 sample database connect?
What is db2 catalog database?
Which isolation level provides highest data integrity?
How will you return the number of records in table?
What is bind package and plan in db2?
Which command is used to remove all rows from a table?
can all users have the privilage to use the sql statement select * (dml)?
How do I copy a table in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
