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 does db2 mean?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is blu acceleration in db2?
What kind of database is db2?
What is the role of union all and union
If I have a view which is a join of two or more tables, can this view be updateable?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
what is the sqlcode -501
What is a plan and package in db2?
What is schema in db2?
What are host variables in db2?
Is db2 a programming language?
What is null indicator in cobol db2?
How to find the number of rows in a db2 table?
What are foreign keys in db2?