Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22358 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
What is db2 and what is the use of db2 optimizer?
What is with ur in db2?
What is the use of runstats in db2?
What is phantom read in db2?
Explain the contents that are a part of dclgen.
What is the use of with ur in db2?
What is a db2 package?
Explain about mirror activator disk mirroring?
What is a storage group (stogroup)?
What is the maximum size of a char data type in db2?
What is access path in db2?
What are the two types of logging in the db2 database? Explain them.
What is a db2 collection?
List down the data types in the db2 database.
What is plan in cobol db2?
