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 |
Explain the use of ignore option in imp command.
What to do if the startbd.bat failed to start the xe instance?
How to write a query with a left outer join in oracle?
How to restrict the duplicate records in table valuesets
how to unbreak sequence numbers during intereptions
what is candidate key & super key
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to execute a stored program unit?
difference between procedures and function?
List out the types of joins.
What is Database Trigger ?
How to find out what privileges a user currently has in oracle?