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 attributes of cursor?
How to speed up webrick?
What is bind variable in oracle 11g?
How to delete an existing row from a table in oracle?
What is an external table?
What is Reduced List of Values?
How to rename an index in oracle?
How would you begin to troubleshoot an ORA-3113 error?
Why do we use bulk collect in oracle?
Explain the characteristics of oracle dba?
Explain an exception?
What is a named program unit?
What is coalesce function?
Please explain joins in oracle?
What is execute immediate in oracle?