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
How is the value function used?
How do I change the column size in db2?
What are the two types of logging in the db2 database? Explain them.
Why cursor is used 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.
How to run db2 command in windows?
What does db2 mean?
What is schema in db2?
What is access path in db2?
what is utility for parm lib
What is a dbrm in db2?
What is dclgen in db2?
What is load utility in db2?
What is the maximum size of a char data type in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.