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 |
What privilege is needed for a user to connect to oracle server?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Can select statements be used on views in oracle?
How to sort the query output in oracle?
definition of cluster and non-clustered index?
What is different bet native dynamic sql and Dbms_Sql?
How to connect to a local oracle 10g xe server?
Explain the use of control file?
How do you bind variables in oracle?
How many types of table in Oracle?
What is format trigger?
How to define a cusotmer as a supplier in ORACLE R12