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
defination of bitmap index
How to drop an index in oracle?
What is a sub query? Describe its types?
Describe varray?
How to count duplicated values in a column in oracle?
What are advantages of dateset in datastage?
Explain an index segment?
What are operators in oracle?
How to drop a stored procedure in oracle?
How to run create database statement?
What is execute immediate in oracle?
Can you drop an index associated with a unique or primary key constraint?
Explain the use of indexes option in imp command.
What is the usage of merge statement?
What is a table index?