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.

What is null indicator in db2?

1122

---

How can you find out the # of rows updated after an update statement?

1117

---

What is meant by dclgen?

1120

---

What is database alias db2?

1133

---

What is the maximum size of varchar data type in db2?

1139

---

What are the 2 sqlcodes that are returned?

1197

---

How do I change the column size in db2?

1165

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3163

---

What is the use of with ur in db2?

1061

---

Is ibm db2 open source?

1083

---

What is collection in db2 bind?

1022

---

Why do we need reorg in db2?

999

---

How will you return the number of records in table?

946

---

What kind of database is db2?

1042

---

How to test SQL -911 error while developing COB-DB2 program

7592

---