Interested to Buy Any Domain ? << Click Here >> for more details...
Normalization in DB2 – first normal form, second normal form
- 4 Answers
- 22359 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 difference between cursor and select statement?
can all users have the privilage to use the sql statement select * (dml)?
How can the duplicate values be eliminated from db2 select?
What do you mean by commit and rollback?
How to connect to db2 database from windows command line?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to view db2 table structure?
What is meant by explain?
What is with ur in db2?
What are the rules for db2 programming?
How is the value function used?
What is the usage of open cursor command?
How does cobol compile db2 program?
Explain the contention situations caused by locks?
What is bind plan?
