Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization? Explain different levels of
normalization?
- 8 Answers
- 63407 Views
- CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhash vandewar
Normalizatiin is the scientific method of breaking down
complex table sturcture into simple table structure by
using certain rules.using this method you can reduce
redundency in a table and eliminate the problem of
inconsisteny and disk space usage.
First Normal Form(1NF):
a table is said to be in first normal form when each
cell of the table prcisely contain one value.
Second Normal Form (2NF):
a table is said to be in second normal form when it is
in 1NF and every attribute in the row in functionaly
dependent upon whole key and not just a part of key.
Third Normal Form (3NF):
a table is said to be in second normal form when it is 2NF
and every non key attribute is functionaly dependent only
on the primary key.
| Is This Answer Correct ? | 27 Yes | 7 No |
Post New Answer View All Answers
explain detail about ftp in datastage?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to use timestamp datatypes
How can I detect whether a given connection is blocked?
What is the database development process?
Explain what a database is?
Explain about post-relational databases?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What are the types of database model?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Who are end users in dbms?
Explain about relational database management systems?
Explain about the hierarchical model of the database?
