Define Normalization with example?
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 |
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
Why is oracle database so popular?
How to write date and time interval literals in oracle?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What do you mean by a deadlock?
What is the purpose of save points in oracle database?
what are the differen between key flexifild and discriptive fiexifild.
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to change program global area (pga) in oracle?
What is a Database instance ? Explain?
What privilege is needed for a user to create views in oracle?
How to start a new transaction in oracle?