(*5(*3 °±² ³ 2! ³ 1-N[SSQ`XXX³\TT[SS 8R`XXX`XXXVNN\TT[SS 1-N[SSQ\TTZZZaYYY
±
Original Data ± Unnormalized
²
customer name
address
state
country
email
phone ° ³land´
phone µ ³cell´
phone ¶ ³fax´
order date·time
product ° ³Q¸P´
product µ ³Q¸P´
product ¶ ³Q¸P´
product ¹ ³Q¸P´
product º ³Q¸P´
± ,.aYYYUMN[SS 1-\TT\TT]UUUR_WWW
´°±µ <DVNNYQQXPPVNN[SS`XXX\TT[SS *,\TT
41-
:8(*
RUM\TT\TT]UUUR_WWW')PRZRR\TT]UUUYQQ`XXX
´±$ ³! ! # ³°" ²#
´±$ ³! " " ³±# ´°
²°¶²´¶µ²±# µµ%!#±±%!#´# ´´µ°´$ ·± ') °¸´$ ¹
" $ µ°´ ·° ') °$ ¸$ $ ¹
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRR$ ´$ ³ # ²³# ´$ $
µ±¶² ¶µ²±# ± %!#° %!#´"
$ ´$ ´µ° ·µ ') $ ¸$ $ ¹
$ ´²µ°´ ·± ') ± ¸ ²¹
´´µ°´$ ·± ') °¸´$ ¹
" " µµ´± ·± ') µ°¸ ²¹
±±µ°# ´ ·µ ') µ¸$ $ ¹
°
+-\\\N^^^[SSR 1-NYQQR^^^
´ ! " 0VNN[SS[SSR^^^ 8aYYY_WWWRRaYYY*,(*
:8(*
Q\\\NUMYQQ')[[[R_WWWaYYYVNN\TT]]]`XXX¸P\TT
! µ³! $ ! ³$ ´´µ
! µ³°°µ³" " " !
! µ³! $ " ³! ±# °
±" ¶²±¶µ²±# ²°%!#°´%!#´´
µ°´µ°´ ·± ') ´°¸ ²¹
´ *,N_WWWN 1-ZZZ_WWW`XXXaYYY
µ² " )+R[SS 8aYYY_WWWRRaYYY
31-
:8(*
PUMZZZ_WWW`XXXaYYY')XPP\TTYQQQR_WWWSK¸P\TTZRR! ²°³µ°´³# ±"
µ" ¶²µ¶µ²±# ±´%!#²$ %!#°µ
$ ² µ´° ·´ ') ²¸$ $ ¹
# ´# °´´ ·! ') ´¸# $ ¹
1N_WWWN 1-\TTYQQaYYY
´" ! ´ 7NSKR 1N[SSR
28
:8(*
YQQN_WWWN')Q_WWWN]UUUR`XXX]]]¸P\TTZRR ! ! µ³" µ$ ³±°" !
°²¶²! ¶µ²±# ²" %!# ´%!#±$
# ´°µ´ ·µ ') ±µ¸ ²¹
°# $ ´µ² ·° ') ´¸$ $ ¹
" $ µ°´ ·± ') °$ ¸$ $ ¹
! 3\TTRYQQYQQR 3RYQQ`XXX\TT[SS
µ$ " ! 1VNNOR_WWWaYYY^^^ 8aYYY_WWWRRaYYY 8*,
:8(*
[SS\TTRYQQYQQR')\TT]UUUR_WWWaYYY\TT[SS`XXX^^^`XXX
# ! ´³´$ " ³$ ! ! µ
# ²°³$ " ´³" " ±
±´¶²±¶µ²±# ±±%!#°# %!#°²
±$ ´ °² ·° ') # ¸´$ ¹
"
+-N[[[\TT[SS 5R_WWWR___
µ$ µ 5N`XXX`XXXNVNNP 8aYYY_WWWRRaYYY 33/
:8(*
Q]UUUR_WWW')SKVNN_WWW]UUU\TTXPPR¸P\TTZRR
°! ²³´°°³! °²²
µ²¶²µ¶µ²±# ²´%!# °%!#´$
" °´°²´ ·± ') ´¸´$ ¹
! $ ´°´± ·° ') µ´¸$ $ ¹
°$ µ´ µ ·µ ') " ¸$ $ ¹
°st Normal Form ³°NF´
`orders`
order_id
customer_name
address
state
country
email
order_date
quantity
product_id
± ,.aYYYUMN[SS 1-\TT\TT]UUUR_WWW
´°±µ <DVNNYQQXPPVNN[SS`XXX\TT[SS *,\TT
41-
:8(*
RUM\TT\TT]UUUR_WWW')PRZRR\TT]UUUYQQ`XXX
²°¶²´¶µ²±# µµ%!#±±%!#´
±
±
± ,.aYYYUMN[SS 1-\TT\TT]UUUR_WWW
´°±µ <DVNNYQQXPPVNN[SS`XXX\TT[SS *,\TT
41-
:8(*
RUM\TT\TT]UUUR_WWW')PRZRR\TT]UUUYQQ`XXX
²°¶²´¶µ²±# µµ%!#±±%!#´
°
µ
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRRµ±¶² ¶µ²±# ± %!#° %!#´
µ
°
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRRµ±¶² ¶µ²±# ± %!#° %!#´
±
´
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRRµ±¶² ¶µ²±# ± %!#° %!#´
±
µ
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRRµ±¶² ¶µ²±# ± %!#° %!#´
±
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRRµ±¶² ¶µ²±# ± %!#° %!#´
µ
!
°
+-\\\N^^^[SSR 1-NYQQR^^^
´ ! " 0VNN[SS[SSR^^^ 8aYYY_WWWRRaYYY*,(*
:8(*
Q\\\NUMYQQ')[[[R_WWWaYYYVNN\TT]]]`XXX¸P\TT
±" ¶²±¶µ²±# ²°%!#°´%!#´
±
"
´
*,N_WWWN 1-ZZZ_WWW`XXXaYYY
µ² " )+R[SS 8aYYY_WWWRRaYYY
31-
:8(*
PUMZZZ_WWW`XXXaYYY')XPP\TTYQQQR_WWWSK¸P\TTZRRµ" ¶²µ¶µ²±# ±´%!#²$ %!#°
´
#
´
*,N_WWWN 1-ZZZ_WWW`XXXaYYY
µ² " )+R[SS 8aYYY_WWWRRaYYY
31-
:8(*
PUMZZZ_WWW`XXXaYYY')XPP\TTYQQQR_WWWSK¸P\TTZRRµ" ¶²µ¶µ²±# ±´%!#²$ %!#°
!
$
1N_WWWN 1-\TTYQQaYYY
´" ! ´ 7NSKR 1N[SSR
28
:8(*
YQQN_WWWN')Q_WWWN]UUUR`XXX]]]¸P\TTZRR °²¶²! ¶µ²±# ²" %!# ´%!#±
µ
±²
1N_WWWN 1-\TTYQQaYYY
´" ! ´ 7NSKR 1N[SSR
28
:8(*
YQQN_WWWN')Q_WWWN]UUUR`XXX]]]¸P\TTZRR °²¶²! ¶µ²±# ²" %!# ´%!#±
°
±±
1N_WWWN 1-\TTYQQaYYY
´" ! ´ 7NSKR 1N[SSR
28
:8(*
YQQN_WWWN')Q_WWWN]UUUR`XXX]]]¸P\TTZRR °²¶²! ¶µ²±# ²" %!# ´%!#±
±
µ
! 3\TTRYQQYQQR 3RYQQ`XXX\TT[SS
µ$ " ! 1VNNOR_WWWaYYY^^^ 8aYYY_WWWRRaYYY 8*,
:8(*
[SS\TTRYQQYQQR')\TT]UUUR_WWWaYYY\TT[SS`XXX^^^`XXX
±´¶²±¶µ²±# ±±%!#°# %!#°
°
±µ
"
+-N[[[\TT[SS 5R_WWWR___
µ$ µ 5N`XXX`XXXNVNNP 8aYYY_WWWRRaYYY 33/
:8(*
Q]UUUR_WWW')SKVNN_WWW]UUU\TTXPPR¸P\TTZRR
µ²¶²µ¶µ²±# ²´%!# °%!#´
±
±°
"
+-N[[[\TT[SS 5R_WWWR___
µ$ µ 5N`XXX`XXXNVNNP 8aYYY_WWWRRaYYY 33/
:8(*
Q]UUUR_WWW')SKVNN_WWW]UUU\TTXPPR¸P\TTZRR
µ²¶²µ¶µ²±# ²´%!# °%!#´
°
±´
"
+-N[[[\TT[SS 5R_WWWR___
µ$ µ 5N`XXX`XXXNVNNP 8aYYY_WWWRRaYYY 33/
:8(*
Q]UUUR_WWW')SKVNN_WWW]UUU\TTXPPR¸P\TTZRR
µ²¶²µ¶µ²±# ²´%!# °%!#´
µ
±
`customer_phones`
`products`
phone_id
phone_number
phone_type
order_id
product_id
product_number
price
± ´±$ ³! ! # ³°" ²#
YQQN[SSQ
±
±
´´µ°´$
°¸´$
µ ´±$ ³! " " ³±# ´°
PRYQQYQQ
±
µ
" $ µ°´
°$ ¸$ $
°
$ ´$ ³ # ²³# ´$ $
YQQN[SSQ
µ
°
$ ´$ ´µ°
$ ¸$ $
´
! µ³! $ ! ³$ ´´µ
YQQN[SSQ
°
´
$ ´²µ°´
± ¸
! µ³! $ ! ³$ ´´µ
PRYQQYQQ
°
" " µµ´±
µ°¸
!
! µ³! $ ! ³$ ´´µ
SKN]]]
°
!
±±µ°# ´
µ¸$ $
" ! ²°³µ°´³# ±"
YQQN[SSQ
´
"
µ°´µ°´
´°¸
# ! ! µ³" µ$ ³±°" !
YQQN[SSQ
#
$ ² µ´°
²¸$ $
$ # ! ´³´$ " ³$ ! ! µ
YQQN[SSQ
!
$
# ´# °´´
´¸# $
±² # ²°³$ " ´³" " ±
PRYQQYQQ
!
±²
# ´°µ´
±µ¸
±± °! ²³´°°³! °²²
YQQN[SSQ
"
±±
°# $ ´µ²
´¸$ $
±µ
±$ ´ °²
# ¸´$
±°
" °´°²´
´¸´$
±´
! $ ´°´±
µ´¸$ $
±
°$ µ´ µ
" ¸$ $
µnd Normal Form ³µNF´
`orders`
`customer_phones`
`products`
order_id
product_id
quantity
phone_id
phone_number
phone_type
order_id
product_id
product_number
price
±
±
±
± ´±$ ³! ! # ³°" ²#
YQQN[SSQ
±
±
´´µ°´$
°¸´$
±
µ
°
µ ´±$ ³! " " ³±# ´°
PRYQQYQQ
±
µ
" $ µ°´
°$ ¸$ $
µ
°
µ
°
$ ´$ ³ # ²³# ´$ $
YQQN[SSQ
µ
°
$ ´$ ´µ°
$ ¸$ $
µ
´
±
´
! µ³! $ ! ³$ ´´µ
YQQN[SSQ
°
´
$ ´²µ°´
± ¸
µ
µ
±
! µ³! $ ! ³$ ´´µ
PRYQQYQQ
°
" " µµ´±
µ°¸
µ
±
!
! µ³! $ ! ³$ ´´µ
SKN]]]
°
!
±±µ°# ´
µ¸$ $
µ
!
µ
" ! ²°³µ°´³# ±"
YQQN[SSQ
´
"
µ°´µ°´
´°¸
°
"
±
# ! ! µ³" µ$ ³±°" !
YQQN[SSQ
#
$ ² µ´°
²¸$ $
´
#
´
$ # ! ´³´$ " ³$ ! ! µ
YQQN[SSQ
!
$
# ´# °´´
´¸# $
´
$
!
±² # ²°³$ " ´³" " ±
PRYQQYQQ
!
±²
# ´°µ´
±µ¸
±²
µ
±± °! ²³´°°³! °²²
YQQN[SSQ
"
±±
°# $ ´µ²
´¸$ $
±±
°
±µ
±$ ´ °²
# ¸´$
µ
±
±°
" °´°²´
´¸´$
!
±µ
°
±´
! $ ´°´±
µ´¸$ $
"
±°
±
±
°$ µ´ µ
" ¸$ $
"
±´
°
"
±
µ
`customer_orders`
customer_id
order_id
customer_name
address
state
country
email
order_date
µ²´!
± ,.aYYYUMN[SS 1-\TT\TT]UUUR_WWW
´°±µ <DVNNYQQXPPVNN[SS`XXX\TT[SS *,\TT
41-
:8(*
RUM\TT\TT]UUUR_WWW')PRZRR\TT]UUUYQQ`XXX
²°¶²´¶µ²±# µµ%!#±±%!#´
! # $ µ
µ *,RYQQVNNN 8PUM_WWW\TTRQR_WWW
µ" µ² 2ZZZYQQOR_WWW_WWW^^^ 1N[SS
/+1
:8(*
PRYQQVNNN`XXX')UM\TTZZZ_WWWYQQP`XXX¸P\TTZRRµ±¶² ¶µ²±# ± %!#° %!#´
$ # ´±
°
+-\\\N^^^[SSR 1-NYQQR^^^
´ ! " 0VNN[SS[SSR^^^ 8aYYY_WWWRRaYYY*,(*
:8(*
Q\\\NUMYQQ')[[[R_WWWaYYYVNN\TT]]]`XXX¸P\TT
±" ¶²±¶µ²±# ²°%!#°´%!#´
²´!
´
*,N_WWWN 1-ZZZ_WWW`XXXaYYY
µ² " )+R[SS 8aYYY_WWWRRaYYY
31-
:8(*
PUMZZZ_WWW`XXXaYYY')XPP\TTYQQQR_WWWSK¸P\TTZRRµ" ¶²µ¶µ²±# ±´%!#²$ %!#°
°! ´$
1N_WWWN 1-\TTYQQaYYY
´" ! ´ 7NSKR 1N[SSR
28
:8(*
YQQN_WWWN')Q_WWWN]UUUR`XXX]]]¸P\TTZRR °²¶²! ¶µ²±# ²" %!# ´%!#±
# µ±°
! 3\TTRYQQYQQR 3RYQQ`XXX\TT[SS
µ$ " ! 1VNNOR_WWWaYYY^^^ 8aYYY_WWWRRaYYY 8*,
:8(*
[SS\TTRYQQYQQR')\TT]UUUR_WWWaYYY\TT[SS`XXX^^^`XXX
±´¶²±¶µ²±# ±±%!#°# %!#°
! ´$ #
"
+-N[[[\TT[SS 5R_WWWR___
µ$ µ 5N`XXX`XXXNVNNP 8aYYY_WWWRRaYYY 33/
:8(*
Q]UUUR_WWW')SKVNN_WWW]UUU\TTXPPR¸P\TTZRR
µ²¶²µ¶µ²±# ²´%!# °%!#´
