Interested to Buy Any Domain ? << Click Here >> for more details...
Define Normalization with example?
- 1 Answers
- 5022 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 |
can u call user defined functions in select statements
Can we create trigger on materialized view in oracle?
How can we find out the current date and time in oracle?
Where is the export dump file located?
How to use "for" statements in oracle?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
How to define a record variable to store a table row?
What are triggers in oracle?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
what is insert all statement in sql
What is an Oracle index?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
Oracle General 
