Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22158 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
Who uses db2?
What is a db2 cursor?
What is the physical storage length of time data type?
What is with ur in db2?
Explain dclgen.
What is iseries database?
Explain about rct in db2?
How to create backup table in db2?
What is coalesce in db2?
On which levels locks can be applied?
What is the difference between nvl and coalesce?
Mention the various locks that are available in db2.
How do I copy a table in db2?
What is a system catalog table in db2?
What is null value in db2?
