Interested to Buy Any Domain ? << Click Here >> for more details...
Define Normalization with example?
- 1 Answers
- 5064 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a materialised view?
what happened to the global index when I truncate the data in one of the partition?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to create a table index?
What are the oracle differences between nvl and coalesce
What are the factors causing the reparsing of SQL statements in SGA?
Can the query output be sorted by multiple columns in oracle?
difference between truncate and delete ,drop?
What is the difference between pre-select and pre-query?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
how to tune oracle sql queries pls tell me step by step. urgent pls
How do I start tns listener?
Oracle General 
