Normalization in DB2 – first normal form, second normal form
Answer Posted / 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 |
Post New Answer View All Answers
What is the clustering index in the db2 database?
Highlight all the advantages that are attached to a package.
What are types of indexes?
How to restart a DB2 program?
What is cursor in dbms?
What are bind parameters in db2?
What is copy pending status in db2?
What is the difference between using bind () and rebind () methods of naming class?
Explain about cursor stability?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is an instance in db2?
What is db2 bind?
What is copy pending and check pending in db2?
How do I start db2 in windows?
What is the information associated with sysibm.syslinks table?