Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization? Explain different levels of
normalization?
- 8 Answers
- 63113 Views
- CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vikram
The task of a database designer is to structure the data in
a way that eliminates unnecessary duplication and provides a
rapid search path to all necessary information. The process
of refining tables, keys, columns, and relationships to
create an efficient database is called normalization
because there is no redundant, neglected data and normalized
tables produce rapid, efficient joins.
There are 5 different normalization methods.
First Normal Form (1NF): Each field in a table must contain
different information.
Second Normal Form (2NF): All attributes that are not
dependent upon the primary key in a database table must be
eliminated.
Third Normal Form (3NF): No duplicate information is
permitted. So, for example, if two tables both require a
common field, this common field information should be
separated into a different table.
There are 2 more normalization forms, fourth normal form
(4NF) and fifth normal form (5NF), but they are rarely used.
Normalization makes databases more efficient and easier to
maintain.
| Is This Answer Correct ? | 121 Yes | 22 No |
Post New Answer View All Answers
What are the three types of database design?
Why does this query return 0?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
What are the 18 schemas?
How would you design a database for an online site, which would average a million hits a day?
What is dbms and its application?
What are the main phases of database development?
Explain about xml databases?
Who are end users in dbms?
What is dbms explain in brief?
Explain about relational database management systems?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How can I detect whether a given connection is blocked?
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
State the acid rules?
