Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 20489 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan.s
Second normal form (2NF) If a table has a composite key,
all attributes must be related to the whole key:
• The database must meet all the requirements of the
first normal form.
• The relational schema should not have any partial
functional dependency i.e. No proper subset of the primary
key should derive a functional dependency belonging to the
same schema. For example, consider functional dependencies
FD:{AB->C, A->D, C->D} here AB is the primary key, as A->D
this relational schema is not in 2NF.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / mohan.s
First normal form (1NF) lays the groundwork for an
organised database design:
• Ensure that each table has a primary key: minimal
set of attributes which can uniquely identify a record.
• Eliminate repeating groups (categories of data
which would seem to be required a different number of times
on different records) by defining keyed and non-keyed
attributes appropriately.
• Atomicity: Each attribute must contain a single
value, not a set of values.
• 'First normal form' depends on functional
dependency formula f(x)=y. For every value of x there is
value for y.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / mohan.s
The formal classifications describing the level of database
normalization in a data model are called Normal Forms (NF)
and the process of doing this is Normalization.
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / 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 |
What is the SQL Communications Area and what are some of its key fields?
How do I connect my db2 database to ibm?
What is nvl in db2?
How many databases can be created inside an instance in db2 ?
What is the function of buffer manager?
What is the information associated with sysibm.syslinks table?
Explain about dbrm.
What is a Resource Control Table(RCT)? Describe its characteristics.
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
can i code union in cobol-db2 pgm ?
Why cursor is used in db2?
Explain dclgen.
COBOL 
