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 to count duplicated values in a column in oracle?
What is the maximum limit on the number of columns in a table?
What operating systems are supported by oracle database 10g xe?
How do you rate yourself in oracle and sql server ?
What are various constraints used in SQL?
what is difference between cartesian join & cross join even they give same result?
How to convert numbers to characters in oracle?
7. Repeat query (7) but also display all clients who have never ordered anything.
Difference between pre-select and pre-query
How to use "out" parameter properly?
what is null value?
Can we create more than one constraint to column ?