The assignment is designed to be done on your own. The assignment must be your own work, not copied from others or any other

course, textbook, or website. If plagiarism is detected, appropriate consequences will follow. Please refer to Policy ST$2$: Student

academic integrity.

Objective:

$-$ Design databases to meet user needs

Problem Specifications

Consider the following unnormalized data.

ProjectName OwnerContact Phone Category Quantity ItemDescription UnitPrice ExtendedPrice Supplier Discount

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $1200$ Amp Panel $$170\mathrm{.}00$ $$170\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $350$ Watt Breaker $$60\mathrm{.}00$ $$180\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $720$ Watt Breaker $$35\mathrm{.}00$ $$245\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $1515$ Watt Breaker $$35\mathrm{.}00$ $$525\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $20012$ ga$,3$ Wire, per foot $$1\mathrm{.}50$ $$300\mathrm{.}00$ EB Supplies $15\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $30012$ ga$,3$ Wire, per foot $$1\mathrm{.}25$ $$375\mathrm{.}00$ EB Supplies $15\mathrm{.}00\%$

Baker Remodel John Stanley $555-787-8392$ Exterior $35$ Siding, $4$x$8$ feet $$22\mathrm{.}50$ $$787\mathrm{.}50$ Contractor, Inc. $35\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Electrical $1015$ Watt Breaker $$35\mathrm{.}00$ $$350\mathrm{.}00$ EB Supplies $15\mathrm{.}00\%$

Baker Remodel John Stanley $555-787-8392$ Exterior $281$x$4-8$ feet $$4\mathrm{.}75$ $$133\mathrm{.}00$ Contractor, Inc. $35\mathrm{.}00\%$

Baker Remodel John Stanley $555-787-8392$ Exterior $100$ Cedar Shingles, bundle $$65\mathrm{.}00$ $$6,500\mathrm{.}00$ Contractor, Inc. $35\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Interior $15$ Door $$275\mathrm{.}00$ $$4,125\mathrm{.}00$ Interior, Inc. $15\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Interior $15$ Door Hinge Set $$29\mathrm{.}95$ $$449\mathrm{.}25$ Interior, Inc. $15\mathrm{.}00\%$

Highland House Elizabeth Barnaby $555-444-8899$ Interior $15$ Door Handle Set $$52\mathrm{.}50$ $$787\mathrm{.}50$ Interior, Inc. $15\mathrm{.}00\%$

Hew Remodel Ralph Hew $555-298-4244$ Electrical $1$ Panel, $200$ Amp $$170\mathrm{.}00$ $$170\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Hew Remodel Ralph Hew $555-298-4244$ Electrical $250$ Watt Breaker $$60\mathrm{.}00$ $$120\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Hew Remodel Ralph Hew $555-298-4244$ Electrical $520$ Watt Breaker $$35\mathrm{.}00$ $$175\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Hew Remodel Ralph Hew $555-298-4244$ Electrical $2015$ Watt Breaker $$35\mathrm{.}00$ $$700\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Hew Remodel Ralph Hew $555-298-4244$ Electrical $15012$ ga$,3$ Wire, per foot $$1\mathrm{.}50$ $$225\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

Hew Remodel Ralph Hew $555-298-4244$ Electrical $30014$ ga$,3$ Wire, per foot $$1\mathrm{.}25$ $$375\mathrm{.}00$ NW Electric $25\mathrm{.}00\%$

$1-$ Show examples of the three anomalies cases insertion, deletion and modification, if applicable.

$2-$ Using the above data, show in details your assumptions about functional dependencies among the attributes of

data. Please use your knowledge about project management and the provided data to justify your assumptions.

$3-$ Apply $1$NF$,2$NF and $3$NF and BCNF $($if necessary$).$ Show all the steps using relation structure. Show clearly different

type of keys.

$4-$ Use your name as the assignment file and save it in Word format. Other formats will not be graded