P $5-9$ Transform the database structure that appears in Figure $5\mathrm{.}15$ into $3$NF$.$ Be sure to show your intermediate steps of $1$NF and $2$NF$.$

Figure $5\mathrm{.}15$ Unnormalized Relation for Problem $5-9$

$\backslash$table$[[$SOFTWARE$,,,,,,],[$PACKID$,$TAGNUM,COMPID,INSTDATE,SOFTCOST,EMPNUM,EMPNAME,LOCATION$],[$AC$01,32808,$M$759,9/13/06,754\mathrm{.}95,611,$Dinh, Melissa,Accounting$],[$DB$32,32808,$M$759,12/13/06,380\mathrm{.}00,611,$Dinh, Melissa,Accounting$],[,37691,$B$121,06/15/06,380\mathrm{.}00,124,$Alvarez, Ramon,Sales$],[$DB$33,57772,$C$007,05/27/06,412\mathrm{.}77,567,$Feinstein, Betty,Info Systems$],[$WP$08,37691,$B$121,06/15/06,227\mathrm{.}50,124,$Alvarez, Ramon,Sales$],[,57772,$C$007,05/27/06,170\mathrm{.}24,567,$Feinstein, Betty,Info Systems$],[$WP$09,59836,$B$221,10/30/06,35\mathrm{.}00,124,$Alvarez, Ramon,Home$],[,77740,$M$759,05/27/06,35\mathrm{.}00,567,$Feinstein, Betty,Home$]]$

KEY:

PACKID $=$ Software package identification code

TAGNUM $=$ Fixed asset inventory tag number

COMPID $=$ Computer model

INSTDATE $=$ Date software was installed on the computer

SOFTCOST $=$ Cost of the particular package installed

EMPNUM $=$ Employee identification code

EMPNAME $=$ Employee name

LOCATION $=$ Location of the computer

Source: Table and data adapted from Philip J$.$ Pratt and Joseph J$.$ Adamski, Database Systems Management and Design, $3$rd ed$.($Danvers$,$ MA: Boyd & Fraser Publishing Company, $1994)$: $218,$ with permission of Boyd & Fraser Publishing Company. All rights reserved.