<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
p.Pa15, li.Pa15, div.Pa15
{mso-style-name:Pa15;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
mso-line-height-alt:11.05pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.Pa4, li.Pa4, div.Pa4
{mso-style-name:Pa4;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
mso-line-height-alt:11.05pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.Pa17, li.Pa17, div.Pa17
{mso-style-name:Pa17;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
mso-line-height-alt:11.05pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.Pa18, li.Pa18, div.Pa18
{mso-style-name:Pa18;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
mso-line-height-alt:11.05pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.Default, li.Default, div.Default
{mso-style-name:Default;
margin:0cm;
margin-bottom:.0001pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
p.Pa9, li.Pa9, div.Pa9
{mso-style-name:Pa9;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
mso-line-height-alt:11.05pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.Pa13, li.Pa13, div.Pa13
{mso-style-name:Pa13;
mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
mso-line-height-alt:11.05pt;
text-autospace:none;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.A7
{mso-style-name:A7;
mso-style-priority:99;
color:#221E1F;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1340809632;
mso-list-type:hybrid;
mso-list-template-ids:1061850430 946511668 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-weight:bold;}
@list l0:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=Pa15 style='mso-margin-top-alt:8.0pt;margin-right:0cm;margin-bottom:
2.0pt;margin-left:0cm'><span style='font-family:"Calibri","sans-serif"'>Hi
everyone</span><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Can
someone please help me with this Sample Exam question. I am trying to
understand table normalization. I have a general understanding of what it means,
but I’m not really sure about the actual differences in this particular
question between the second and third normal forms. As a class we have been
going through the textbook definition, but I’m struggling to apply it to
this particular sample question. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Also
if anyone has some good resources on a simple (not so technical way) of how to
explain this easier it would be greatly appreciated.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Thanks</span><b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
<p class=Pa15 style='mso-margin-top-alt:8.0pt;margin-right:0cm;margin-bottom:
2.0pt;margin-left:0cm'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#221E1F'>Question 1</span></b><span style='font-size:10.0pt;font-family:
"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
<p class=Pa4 style='margin-bottom:2.0pt;text-align:justify'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'>Below
is a table from a yacht club’s relational database.<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width=652
style='border-collapse:collapse;border:none'>
<tr style='height:18.55pt'>
<td width=98 valign=top style='width:73.7pt;border:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa17 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Name</span></b></span><b><span
style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=71 valign=top style='width:53.35pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa17 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Boat
Name</span></b></span><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";
color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=125 valign=top style='width:93.55pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa17 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Address_Suburb</span></b></span><b><span
style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=60 valign=top style='width:44.95pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>State</span></b></span><b><span
style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=71 valign=top style='width:53.35pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>memType</span></b></span><b><span
style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=57 valign=top style='width:42.5pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Fees
$</span></b></span><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";
color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=57 valign=top style='width:42.5pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Gender</span></b></span><b><span
style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=57 valign=top style='width:42.5pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Boat
Storage Fees $</span></b></span><b><span style='font-size:8.0pt;font-family:
"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></b></p>
</td>
<td width=57 valign=top style='width:42.5pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:18.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Total
Fees Due $</span></b></span><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";
color:#221E1F'><o:p></o:p></span></b></p>
</td>
</tr>
<tr style='height:12.55pt'>
<td width=98 valign=top style='width:73.7pt;border:solid windowtext 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa4 style='margin-bottom:2.0pt;text-align:justify'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Sue Trowsdale</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=71 valign=top style='width:53.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Suzy</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=125 valign=top style='width:93.55pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa4 style='margin-bottom:2.0pt;text-align:justify'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>21 Mountain Rd
Rosebud</span></span><span style='font-size:9.0pt;font-family:"Arial","sans-serif";
color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=60 valign=top style='width:44.95pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>VIC</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=71 valign=top style='width:53.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Senior</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>250.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>F</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>125.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>375.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
</tr>
<tr style='height:12.55pt'>
<td width=98 valign=top style='width:73.7pt;border:solid windowtext 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Jon Ross</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=71 valign=top style='width:53.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Wahoo</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=125 valign=top style='width:93.55pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>64 View Rd McCrae</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=60 valign=top style='width:44.95pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>VIC</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=71 valign=top style='width:53.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Junior</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>140.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>M</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>–</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>140.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
</tr>
<tr style='height:12.55pt'>
<td width=98 valign=top style='width:73.7pt;border:solid windowtext 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Harry Wilson</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=71 valign=top style='width:53.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Victor</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=125 valign=top style='width:93.55pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa17 style='margin-bottom:2.0pt'><span class=A7><span
style='font-size:9.0pt;font-family:"Arial","sans-serif"'>35 Shady Ln Rosebud</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=60 valign=top style='width:44.95pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>VIC</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=71 valign=top style='width:53.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Life</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>–</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>M</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>125.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
<td width=57 valign=top style='width:42.5pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:12.55pt'>
<p class=Pa18 align=center style='margin-bottom:2.0pt;text-align:center'><span
class=A7><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>125.00</span></span><span
style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN-AU style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=Pa13 align=right style='margin-bottom:5.0pt;text-align:right'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'>2 marks<o:p></o:p></span></p>
<p class=Pa9 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:2.0pt;
margin-left:21.3pt;text-align:justify;text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'><span
style='mso-list:Ignore'>a.<span style='font:7.0pt "Times New Roman"'>
</span></span></span></b><![endif]><span style='font-size:10.0pt;font-family:
"Arial","sans-serif";color:#221E1F'>Describe what would happen when you apply <b>one
</b>of the First, Second or Third Normal Forms to data in the table. Refer to
the table in your answer. <o:p></o:p></span></p>
<p class=Pa9 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:2.0pt;
margin-left:22.0pt;text-align:justify;text-indent:-22.0pt'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'><o:p> </o:p></span></p>
<p class=Pa9 style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:2.0pt;
margin-left:22.0pt;text-align:justify;text-indent:-22.0pt'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'>Tick
the box to indicate which normal form you are describing. <o:p></o:p></span></p>
<p class=Default style='mso-margin-top-alt:5.0pt;margin-right:0cm;margin-bottom:
2.0pt;margin-left:22.0pt;text-align:justify;text-indent:-22.0pt;line-height:
11.05pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#221E1F'> First </span><span style='font-size:10.0pt;
font-family:Wingdings;color:#221E1F'>o</span><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:#221E1F'>
or Second </span><span
style='font-size:10.0pt;font-family:Wingdings;color:#221E1F'>o</span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'>
or Third </span><span
style='font-size:10.0pt;font-family:Wingdings;color:#221E1F'>o</span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#221E1F'> <o:p></o:p></span></p>
<p class=Default style='line-height:115%'><span style='font-size:10.0pt;
line-height:115%;font-family:"Arial","sans-serif"'>____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________<o:p></o:p></span></p>
<p class=Default style='line-height:115%'><span style='font-size:10.0pt;
line-height:115%;font-family:"Arial","sans-serif"'>____________________________________________________________________________________<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>Laura
Fihelly<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>Teacher
of Business Management & Information Technologies<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>Catholic
Regional College Sydenham<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>380
Sydenham Road <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>Sydenham
3037<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>email:
<a href="mailto:fihl@crcsydenham.net">fihl@crcsydenham.net</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif";color:#1F497D'>web:
</span><a href="http://www.crcsydenham.net/"><span style='font-family:"Arial","sans-serif"'>www.crcsydenham.net</span></a><span
style='font-family:"Arial","sans-serif";color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>