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
Explain overloading. Can functions be overloaded?
How to use "if" statements on multiple conditions?
What is oracle and what are its different editions?
Differentiate between pre-select and pre-query?
6. Display the client name and order date for all orders using the traditional method.
material view and view disadvantages?
What is oracle used for?
How to empty your oracle recycle bin?
How to use null as conditions in oracle?
what is the dual table in oracle?
What is recycle bin in Oracle?
WHAT IS ecc 6.0
What is data file?
Where do we use decode and case statements?
What is null value in oracle?