Normalization in DB2 – first normal form, second normal form
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
Mention the location where the output received from explain statement is stored.
How can we read records for specific member in CL? AND rpg?
How does coalesce work?
What is netezza database?
How to retrieve rows from a db2 table in embedded sql?
What is sqlca’s maximum length?
What is the cobol picture clause of the db2 data types date, time, timestamp?
If I have a view which is a join of two or more tables, can this view be updateable?
define clustering index.
Mention the different locking levels that are available in db2.
Is db2 relational database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do I import data from excel to db2?
What is the physical storage length of date data type?
Is ibm db2 free?