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
What is the difference between cursor and select statement?
What is clone table?
How do I delete a table in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is cursor with hold option in db2?
How to check last update on table in db2?
How do I add a column to an existing table in db2?
What type of database is db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How do I delete a table in database?
What is the max length of sqlca?
What is the maximum size of varchar data type in db2?
What is runstats utility in db2?
How will you return the number of records in table?
List some fields from sqlca?