Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 21949 Views
- Virtusa, I also Faced
- E-Mail Answers
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 connection string to connect to the DB2 Database ?
What do you mean by between and in? Is between inclusive of specified range values?
i want to maintain uniqueness on pdf without make lf??????????
Who uses db2?
Highlight all the advantages that are attached to a package.
When the like statement is used?
What language is db2 written in?
Is schema the same as database?
What is the maximum No of rows per page?
How do you stop a db2 database in linux?
How can you do the explain of a dynamic sql statement?
What is catalog database in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the purpose of rollback and commit?
What is table space in db2?
