Question: 1 ) . Each Vendor has a unique VendorId. Each activity has a unique code. Each PurchaseOrder has a unique POnumber. Each payment has a
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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
