Assignment Instructions

Illustrate deletion, modification, and insertion anomalies on the STUDENT$\_$ACTIVITY relation in Figure.

Here is the STUDENT$\_$ACTIVITY table:

STUDENT$\_$ACTIVITY Table

$\backslash$table$[[$StudentID$,$StudentName,Activity,ActivityFee,AmounttPaid$],[100,$Jones,Golf,$65\mathrm{.}00,65\mathrm{.}00],[100,$Jones,Skiing,$200\mathrm{.}00,0\mathrm{.}00],[200,$Davis,Skiing,$200\mathrm{.}00,0\mathrm{.}00],[200,$Davis,Swimming,$50\mathrm{.}00,50\mathrm{.}00],[300,$Garrett,Skiing,$200\mathrm{.}00,100\mathrm{.}00],[300,$Garrett,Swimming,$50\mathrm{.}00,50\mathrm{.}00],[400,$Jones,Golf,$65\mathrm{.}00,65\mathrm{.}00],[400,$Jones,Swimming,$50\mathrm{.}00,50\mathrm{.}00]]$

Consider the relation:

PERSON $($Name$,$ Sibling, ShoeSize$)$

Assume the following functional dependencies exist:

Name $->$Sibling

Name $->->$ShoeSize

Describe deletion, modification, and insertion anomalies for this relation.

Using the data in Figure and adding Shoe$\_$Size, we get the following relation:

ShoeSize Table

$\backslash$table$[[$Name$,$Sibling,ShoeSize$],[$Chau$,$Eileen,C$],[$Chau$,$Jonathan,C$],[$Green$,$Nikki,B$],[$Jones$,$Frank,E$],[$Jones$,$Fred,E$],[$Jones$,$Sally,E$]]$

Guidelines

Include your last name in the filename $($example: Unit$-3$ AS$1$ Smith.$)$

The file must be submitted in either Word or PDF format.

Technical Support

Need help using Canvas Assignments? If so$,$ please review the following:

Canvas Resources for Students $-$ Assignments