Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22103 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
How to connect to db2 database from windows command line?
How do you eliminate duplicate values in db2?
Give the name of some fields form sqlca.
Mention data types used in db2 ?
Define check constraint.
Explain the function of data manager.
What is the maximum number of columns in a db2 table?
What are the two types of logging in the db2 database? Explain them.
What is copy pending and check pending in db2?
What is a system catalog table in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is the use of value function?
What is access path in db2?
What is explain plan in db2?
How to execute stored procedure in db2 command editor?
