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 isolation level in db2?
What is explain plan in db2?
What are the various data types available in db2?
Explain in brief how does db2 determine what lock-size to use?
What are catalog tables in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the connection string to connect to the DB2 Database ?
What is data manager?
How would the varchar column remarks defined?
What is the meaning concurrency in the db2 database?
Why do we need reorg in db2?
How to fetch the last row from the table in SQL (db2)?
When the like statement is used?
What are the prerogatives?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?