Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22188 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
Can you tell me how can you find out the # of rows updated after an update statement?
Name the lockable units in DB2?
What is the default page size of buffer pools?
What does sqlcabc has?
What is a Foreign Key?
What is data manager?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do you stop a db2 database in linux?
If I have a view which is a join of two or more tables, can this view be updateable?
How can the duplicate values be eliminated from db2 select?
What is cobol db2?
What's The Error Code For Unique Index Voilation?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
