Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 21950 Views
- Virtusa, I also Faced
- E-Mail Answers
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
Is db2 relational database?
Comment whether the cursor is closed during commit or not.
How to run db2 command in windows?
what are bind concepts in db2 cobol?
what is utility for parm lib
Explain dclgen.
How to find the maximum value in a column in the db2 database?
How many databases can be created inside an instance in db2 ?
Which component is used to execute the sql statements?
What is db2 connect?
What is dclgen (declaration generator)?
What do you mean by commit and rollback?
What is the difference between using bind () and rebind () methods of naming class?
How to resolve deadlock issue
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
