Interested to Buy Any Domain ? << Click Here >> for more details...
Define Normalization with example?
- 1 Answers
- 5051 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 an oracle?
How to find the duplicate rows count from employees table in oracle?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
What is procedure overloading in oracle?
What happens in oracle commit?
12. Display the client name in upper case only and in lower case only.
How many types of tables are there in oracle?
How to sort the query output in oracle?
How to manage transaction isolation level?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain oracle insert into command?
What are dml statements in oracle?
Oracle General 
