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 use select statement to count the number of rows in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
Is java required for oracle client?
What is Private Database Link ?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
what are the disadvantages of hierarchial database over RDBMS?
What privilege is needed for a user to create tables in oracle?
What is the difference between normal and corelated subqueries?
How do we switch from init.ora file to asp file?
What is raw datatype in oracle?
how to truncate date and get only time part 9:20:00
what is the difference between first normal form & second normal form?