What is Normalization ?

Answer Posted / edward

NORMALIZATION IS THE WAY AND MANA OF REDUCING DUPLICATE IN
A GIVEN ENTITIES.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to synchronize 2 schema's objects?

1690


How does the on-delete-cascade statement work?

606


Explain what are the advantages of views?

611


Can group functions be mixed with non-group selection fields?

534


What is oracle rownum?

520






What is a trigger oracle?

563


How to get a create statement for an existing table?

572


Explain what are the characteristics of data files?

629


What is merge in oracle?

561


Explain temporal data types in oracle

607


How can I introduce multiple conditions in like operator?

553


How to rollback the current transaction in oracle?

538


What happens to indexes if you drop a table?

698


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1700


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1607