Normalization in DB2 – first normal form, second normal form
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 |
how do you resolve -805?
What are delete-connected tables?
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?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
How would you find out the total number of rows in a db2 table?
What is sqlca?
what types of copies can be made with the COPY Utility ?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is a base table?
When is the authorization check on DB2 objects done - at BIND time or run time?
What are db2 objects?
What action db2 takes when a program aborts in the middle of a transaction?