Answer Posted / babu vincent
Normalization:
normalization is used to reduce the repetition..
for example if a table contains a column repeating same datatype and for same purpose..
look at simple example a item purchased of a customer may contain many which also include separate prices so instead of creating repeated column for each item and price.. one table is created with one column for item name and one for column name.. then relationship(one to many) can be created and records in item table can be connected with cstomer table which includes order no as primary key..
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the differences between blob and clob in oracle?
What is a dynamic performance view in oracle?
what are bitmap indexes? How does they work?
List the various oracle database objects?
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.
How do I know if oracle client is installed on windows?
Why does oracle 9i treat an empty string as null?
Explain what are the characteristics of data files?
How to call a stored function with parameters?
Explain the use of record length option in exp command.
What is null value in oracle?
Why do you use stored procedures and state some of its disadvantages?
How to end the current transaction in oracle?
Why is oracle so popular?
How to load data from external tables to regular tables?