Answer Posted / vishnu
In relational Database design, the process of organizing
data to minimize redundancy is called Normalization.
Normalization usually involves dividing a database into two
or more tables and defining relationship b/w the tables.
1) 1st NF: Eliminate Repeating Group(Column)
2) 2nd NF: Eliminate Redundant Data
3) 3rd NF: Eliminate Columns Not dependent on Primary key
4) 4th NF: Isolate Independent Multiple Relationships
5) 5th NF: Isolate Semantically Related Multiple Relationships
De-normalization is the process of attempting to optimizing
the performance of a database by adding redundant data. It
is sometimes necessary bcoz current DBMSs implement the
relational model poorly. its a technique to move from higher
to lower normal forms of database modeling in order to speed
up database access.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to access the inserted record of an event?
What is the difference between executequery () and executeupdate ()?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is an execution plan? How would you view the execution plan?
How to provide values to user defined function parameters?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How do I clean up sql server transaction log?
what stored procedure would you use to view lock information? : Sql server administration
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Write a sql query to get zero records from a table having n number of records?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Can you explain what are commit and rollback in sql?
What command must you use to include the not null constraint after a table has already been created?
what are different types of backups available in sql server? : Sql server database administration
Explain a join?
