Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 21951 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is ibm db2 open source?
Which is faster delete or truncate?
What kind of database is db2?
Explain about rct.
How do you select a row using indexes in db2?
Explain package in db2 and its advantages?
what are bind concepts in db2 cobol?
How do you stop a db2 database in linux?
What is syscat in db2?
Where can you declare a cursor in a cobol-db2 program?
What is cloudant database?
How to connect to db2 database from windows command line?
Mention the location where the output received from explain statement is stored.
What is the role of data manager in the db2 database?
What are the different types of base tables?
