Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is microsoft sql server?
Do you know what are pages and extents? : SQL Server Architecture
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?
What are the aggregate and scalar functions?
How to list all user defined functions in the current database?
What is function of ROLLUP ?
Explain datetimeoffset data type in sal server 2008?
What are filegroups in sql server?
Mention the 3 ways to get a count of the number of records in a table.
What is sql server profiler?
Why do we need different type of parameter?
What is merge statement?
What is the New in SQL server 2008?
What is sql server programming?
What is the default Port No on which SQL Server listens?
