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 |
What does nvl stand for?
what is sql server? : Sql server database administration
What are the different types of upgrades that can be performed in sql server?
Which joins are sql server default?
user defined datatypes
Is null in sql server?
What are the properties of primary key?
Is sql different from sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Can we rewrite subqueries into simple select statements or with joins? Example?
What is logshipping and its purpose?
Explain the difference between control flow and data flow?