What is normalization? Explain different levels of
normalization?
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 is dbms explain in brief?
How long can an error message be in raiseerror function?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Write short notes on manual refreshes.
How you can make a parameterized view?
Which data type cannot be used as a parameter in a udf?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain about the database management systems.
fact table and dimension table containg one to many relationship or many to one relastionship
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What are the 18 schemas?
How would you design a database for an online site, which would average a million hits a day?
How to generate OIDS
Why does this query return 0?
Explain about relational database management systems?