Find violated data integrity rules $"1).$ Each Vendor has a unique VendorId. Each activity has a unique code. Each PurchaseOrder has a unique POnumber. Each payment has a unique payment number. $($Hint: these tell you what can be used as the primary key for each table, which is associated with the entity integrity rules.$)$

$2).$ Each payment must be associated with one POnumber.

$3).$ The maximum budget of any activity is $$350,000.$

$4).$ All Purchase Order expiration dates are on or after $1/1/2019.$

$5).$ Each payment can correspond to multiple activity codes. For each payment, the database records the amount coming from each activity code.

Vendor: $($VendorId$,$ Vname, Address, Phone$)$

VendorID VName Address Phone#

V$1001123$ COMPANY $123$ MAIN ST $202-555-0196$

V$1002$ WAYNE ENTERPRISES $1010$ WAYNE ST $202-555-0104$

V$1003$ STARK INDUSTRIES $123442$ND ST $202-555-0167$

V$1004$ DUNDER MIFFLIN $1725$ SLOUGH AVE $202-555-0101$

V$1005$ OSCORP $1180$ AVENUE $202-555-0117$

ActivityCode: $($Code$,$ Fund, Appropriation, BudgetAmt$)$

Code Fund Appropriation BudgetAmt

ENHP Investment Fund Enhancement Projects $$350,000\mathrm{.}00$

FOPR Program Costs Field Operations Projects $$50,000\mathrm{.}00$

LGSP Legal Services Legislative Projects $$25,000\mathrm{.}00$

OFFN Misc Costs Official Functions Expense $$10,000\mathrm{.}00$

PurchaseOrder: $($PONumber$,$ POAmt, ExprDate, Description, VendorID$)$ Foreign Keys: VendorID

PONumber POAmt ExprDate Description Status VendorID

PO$201$ $$15,000\mathrm{.}0019-$Dec$-18$ REMODEL SLB PROPERTY APPROVED V$1001$

PO$202$ $$25,000\mathrm{.}0015-$Jan$-19$ DESIGN FOR RANCH APPROVED V$1002$

PO$203$ $$500\mathrm{.}0026-$Apr$-19$ PEST REMOVAL COMPLETED V$1003$

PO$204$ $$1,000\mathrm{.}0031-$May$-19$ LEGAL REVIEW APPROVED V$1006$

PO$205$ $$250\mathrm{.}0029-$Jun$-19$ OFFICE SUPPLIES PENDING V$1004$

PO$206$ $$5,000\mathrm{.}0031-$May$-19$ EQUIPMENT PENDING V$1002$

Payment: $($PmtNumber$,$ InvNumber, InvDate, PmtAmt, PONumber$)$ Foreign Key: PONumber

PmtNumber InvNumber InvDate PmtAmt PONumber

$1234622-$Apr$-19$ $$2,000\mathrm{.}00$ PO$201$

$2137812-$Mar$-19$ $$10,000\mathrm{.}00$ PO$202$

$3348227-$Apr$-19$ $$500\mathrm{.}00$ PO$204$

$4250302-$Apr$-19$ $$1,000\mathrm{.}00$

$5869610-$Apr$-19$ $$1,000\mathrm{.}00$ PO$201$

$6342025-$Apr$-19$ $$1,000\mathrm{.}00$ PO$202$

$7479326-$Apr$-19$ $$5,000\mathrm{.}00$ PO$201$

$8596829-$Apr$-19$ $$250\mathrm{.}00$ PO$204$

$8483402-$May$-19$ $$100\mathrm{.}00$ PO$204$

$10583903-$May$-19$ $$2,000\mathrm{.}00$ PO$201$

PaymentCode: $($PmtNumber$,$ ActivityCode, PmtAmount$).$ Foreign Keys: PmtNumber, ActivityCode

PmtNumber ActivityCode PmtAmount

$1$ ENHP $$2,000\mathrm{.}00$

$2$ ENHP $$9,000\mathrm{.}00$

$2$ $$1,000\mathrm{.}00$

$3$ ENHP $$500\mathrm{.}00$

$5$ ENHP $$1,000\mathrm{.}00$

$6$ ENHP $$1,000\mathrm{.}00$

$7$ ENHP $$4,000\mathrm{.}00$

$7$ OFFN $$1,000\mathrm{.}00$

$8$ OFFN $$100\mathrm{.}00$

$8$ ENHP $$100\mathrm{.}00$

$8$ ENHP $$50\mathrm{.}00$

$9$ ENHP $$100\mathrm{.}00"$