Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization? Explain different levels of
normalization?
- 8 Answers
- 62834 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
fact table and dimension table containg one to many relationship or many to one relastionship
What are the main phases of database development?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Explain about the database management systems.
How to use timestamp datatypes
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is database design and development?
In which table collections errors are stored.
What is dbms and its application?
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
Explain the rollup operator?
Explain the role of indexing in databases?
How to customize error conditions.
Write the fastest query to find out how many rows exist in a table?
I have a few records all are same structures data, I want to store data in multiple targets how
