Interested to Buy Any Domain ? << Click Here >> for more details...
Define Normalization with example?
- 1 Answers
- 5036 Views
- I also Faced
- E-Mail Answers
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 values from other tables in update statements using oracle?
What is an oracle wallet?
Explain oracle’s system global area (sga).
What are the components of physical database structure in the Oracle database?
Can we create more than one constraint to column ?
What is hot backup and logical backup?
What are the restrictions in a oracle read only transaction?
What is the order of defining local variables and sub procedures/functions?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
How to create a new table in oracle?
does the query needs a hint to access a materialized view?
Explain the use of compress option in exp command.
Oracle General 
