Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedI 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 Access

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Electronic Health Records An Audit And Internal Control Guide

Authors: Rebecca S. Busch

1st Edition

0470258209, 978-0470258200

More Books

Students also viewed these Accounting questions

Question

What are the various roles of HR in organizations?

Answered: 1 week ago

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago

Question

understand the key issues concerning international assignments

Answered: 1 week ago