Answered step by step
Verified Expert Solution
Question
1 Approved Answer
There shoul be 7 Violated Data Integrity rules. Find violated data integrity rules 1 ) . Each Vendor has a unique VendorId. Each activity
There shoul be Violated Data Integrity rules. Find violated data integrity rules 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.
Each payment must be associated with one POnumber.
The maximum budget of any activity is $
All Purchase Order expiration dates are on or after
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 COMPANY MAIN ST
V WAYNE ENTERPRISES WAYNE ST
V STARK INDUSTRIES ND ST
V DUNDER MIFFLIN SLOUGH AVE
V OSCORP AVENUE
ActivityCode: Code Fund, Appr. Thopriation, BudgetAmt
Code Fund Appropriation BudgetAmt
ENHP Investment Fund Enhancement Projects $
FOPR Program Costs Field Operations Projects $
LGSP Legal Services Legislative Projects $
OFFN Misc Costs Official Functions Expense $
PurchaseOrder: PONumber POAmt, ExprDate, Description, VendorID Foreign Keys: VendorID
PONumber POAmt ExprDate Description Status VendorID
PO $Dec REMODEL SLB PROPERTY APPROVED V
PO $Jan DESIGN FOR RANCH APPROVED V
PO $Apr PEST REMOVAL COMPLETED V
PO $May LEGAL REVIEW APPROVED V
PO $Jun OFFICE SUPPLIES PENDING V
PO $May EQUIPMENT PENDING V
Payment: PmtNumber InvNumber, InvDate, PmtAmt, PONumber Foreign Key: PONumber
PmtNumber InvNumber InvDate PmtAmt PONumber
Apr $ PO
Mar $ PO
Apr $ PO
Apr $
Apr $ PO
Apr $ PO
Apr $ PO
Apr $ PO
May $ PO
May $ PO
PaymentCode: PmtNumber ActivityCode, PmtAmount Foreign Keys: PmtNumber, ActivityCode
PmtNumber ActivityCode PmtAmount
ENHP $
ENHP $
$
ENHP $
ENHP $
ENHP $
ENHP $
OFFN $
OFFN $
ENHP $
ENHP $
ENHP $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started