Normalization in DB2 – first normal form, second normal form
Answer Posted / mohan.s
Third normal form (3NF) requires that data stored in a
table be dependent only on the primary key, and not on any
other field in the table.
• The database must meet all the requirements of the
first and second normal form.
• All fields must be directly dependent on the
primary key field. Any field which is dependent on a non-
key field which is in turn dependent on the Primary Key (ie
a transitive dependency) is moved out to a separate
database table.
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is db2 instance?
What are the 2 sqlcodes that are returned?
Define declaration generator (dclgen).
What are the contents of dclgen?
What are the different types of base tables?
What is the syntax for FETCH in DB2 ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is difference between rollback and commit?
Is ibm db2 free?
What is dpf in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain the contention situations caused by locks?
What is a bind in db2?
What is cursor stability in db2?
What is the role of data manager in the db2 database?