Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22151 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 buffer pool and list some of them?
What is node in db2?
What is performance tuning db2?
Can one database have multiple instances?
How connect db2 database to datastage?
What are union and union all?
What is the use of with ur in db2?
What is dbrm? What it contains?
What are the contents of a dclmgen?
List out the three types of page locks that can be held.
What is consistency token in db2?
How does a cursor work?
What is dpf in db2?
Explain the contents that are a part of dclgen.
What is the difference between drop table and delete table?
