|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
May 3rd, 2004, 06:45 AM
|
|||
|
|||
|
Normalization 1,2,3,4 With Example ?
Can anyone Explain me the Normalization concept with example ?
|
|
#2
May 11th, 2004, 10:31 AM
|
|||
|
|||
|
simple normalization
create table xyz "denormalization"
(xyz_id number, xyz_qty number, xyz_price number(7.2), xyz_total number(9.2)); create table xyz "normalization" (xyz_id number, xyz_qty number, xyz_price number(7.2)); you already have xyz_qty and xyz_price, so xyz_total can always be calculated during the select and doesnt need to be stored in the database. This is about as simple as it can be probably explained
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Normalization 1,2,3,4 With Example ? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
