Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 21948 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 |
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is db2 isolation?
How can you quickly find out the # of rows updated after an update statement?
What is db2 purescale?
What is a buffer pool?
Return code 100 means?
When is the skeleton cursor table created?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
Name the lockable units in DB2?
What is query_cache_limit?
What are the three DB2 date and time data types and their associated functions?
What are simple, segmented and partitioned table spaces ?
COBOL 
