What is Normalization ?
- 55 Answers
- 78931 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
Answer Posted / sachin
Normalization is a method of break down complex table’s
structure into simple table structure by using certain
rules. Normalization usually involves dividing a database
into two or more tables and defining relationships between
the tables. The objective of Normalization is to isolate
data so that additions, deletions, and modifications of a
field can be made in just one table and then propagated
through the rest of the database via the defined
relationships. With the help of this method we can reduce
redundancy in a table and remove the problems of
inconsistency and reduce the amount of space.
see more info on this link
http://www.mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What%20is%20Normalization?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
does the query needs a hint to access a materialized view?
Explain about functional dependency and its relation with table design?
what are bitmap indexes? How does they work?
Explain what are synonyms used for?
Why we use bulk collect in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain the use of show option in imp command.
What is analyze command used for?
How many categories of data types in oracle?
what is IDE,DMV in sql server?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to get execution statistics reports on query statements?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to create a new table in your schema?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
