Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help defining the foreign keys and the Multiplicities. Help Please! Events Resources Agents Purchase Fish PKPurchase # Fish code Qty Purch Purchase Price
I need help defining the foreign keys and the Multiplicities. Help Please!
Events Resources Agents Purchase Fish PKPurchase # Fish code Qty Purch Purchase Price PK Fish Inv Fish Code Std cost Retail Price Qty on hand PK 1..1 Fishers fisher # Name Contact Street City PK Cash disb fishers Check # Check Date Fishers # CD Emp# Payroll Check# Check Date Emp# Gross Pay Emp, fica PK PK Employees Employee # Social Sec # Last name First name PK Stores Store Code Phone Address City State PK Timecards Timecard# Timecard date | | Lipiul Emp# Gross Pay Empfica Social Sec # Last name First name PK Stores Store Code Phone Address City State PK Timecards Timecard# Timecard date Reg time Hrs Emp# Store Code PK Customers Customer # Name Phone # Boat name Order Sales Order# Order Date Customer# Emp# Sale Date PK PK Returns Cash Account # Bank description Balance PK Cash Reg PK Rept# Customer# Rcpt date Emp# Account# Return # Return Date Customer # Order # Emp# Directions: Assign the missing multiplicities for all of the associations. Fill in the events column attributes ensuring to identify all the primary (PK) and foreign keys (FK). Use your completed UML Class diagram to then complete the Relationship screen in Access. Events Resources Agents Purchase Fish PKPurchase # Fish code Qty Purch Purchase Price PK Fish Inv Fish Code Std cost Retail Price Qty on hand PK 1..1 Fishers fisher # Name Contact Street City PK Cash disb fishers Check # Check Date Fishers # CD Emp# Payroll Check# Check Date Emp# Gross Pay Emp, fica PK PK Employees Employee # Social Sec # Last name First name PK Stores Store Code Phone Address City State PK Timecards Timecard# Timecard date | | Lipiul Emp# Gross Pay Empfica Social Sec # Last name First name PK Stores Store Code Phone Address City State PK Timecards Timecard# Timecard date Reg time Hrs Emp# Store Code PK Customers Customer # Name Phone # Boat name Order Sales Order# Order Date Customer# Emp# Sale Date PK PK Returns Cash Account # Bank description Balance PK Cash Reg PK Rept# Customer# Rcpt date Emp# Account# Return # Return Date Customer # Order # Emp# Directions: Assign the missing multiplicities for all of the associations. Fill in the events column attributes ensuring to identify all the primary (PK) and foreign keys (FK). Use your completed UML Class diagram to then complete the Relationship screen in AccessStep 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