Normalization and denormalization
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sakthi
Normalization:
Process of decomposing a longer table into
smaller one, by using normalizaton we can fetch the data
faster. there are different types of normalization below
listed are few important one.
1) 1st normal form
2) 2nd normal form
3) 3rd normal form
4) 4th normal form
5) 5th normal form
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pragyan
database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.
de-normalization is the process of attempting to optimize the performance of a database by adding redundant data..
Is This Answer Correct ? | 1 Yes | 0 No |
How do I create a stored procedure in sql server?
How to query multiple tables jointly?
Mention the differences between local and global temporary tables.
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
Define cross join in sql server joins?
Explain indexed view?
Can you explain different types of locks in sql server?
Explain the difference between primary keys and foreign keys?
How to change the name of a database user?
How to disable triggers using "disable trigger"?
Explain fundamentals of Data ware housing & OLAP?
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?