Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I begin to create a UML diagram with this access relationship table? VENDORSMISC FLOWERINVENTORY ORDERSANDSALES I vendor I Inventory I order PURCHASEMISC name

How do I begin to create a UML diagram with this access relationship table?

FLOWERINVENTORY 1 Inventory Flower Name Retail Price Unit Expected Cost 1 POR ORDERSANDSALESITEMS 1 order ORDERSANDSALES 1 or 

VENDORSMISC FLOWERINVENTORY ORDERSANDSALES I vendor I Inventory I order PURCHASEMISC name Flower Name order_date Y PO ORDERSANDSALESITEMS address Retail Price city, state, zip customer purch_date Unit order I Inventory order_emp# vendor Phone Expected Cost sale_date ordering emp# Fax truck_vin expense_amt email cash_receipt website reason store store notes check PURCHASEFLOWERSITEMS check_date CASHRECEIPTS I purchase cd_emp# GROWERS I Inventory I rcpt= I grower account# customer name rept_date cr emp phone_number TRUCKS city store * VIN acquired year state account# store make rept_amt mileage_Jan_1_2018 original_cost useful life PURCHASEFLOWERS est value_end_of_lif annual_dep I purchase EMPLOYEES store purchase_date 1 employee social security_numt grower purch_emp# og truck_VIN Last_Name store_location first_name wage_rate_per_hour store check store STORES 1 Store Phone Address Store Location CASHDISBTOGROWERS State I check Zip check_date Orig purch_price Acquired year CUSTOMERS grower I customer cd_emp# Life Name account# Annual dep PAYROLL Contact check amt CASH I check check date pay to emp# account payroll emp# Street store I account# City bank State Zip store TIMECARDS timecard# * timecard store timecard_date reg_time_hours overtime_hours gross pay emp fica employer_fica emp# emp mc supv_emp# employer_me store fed tax wh state tax wh net pay to_employe 8| 8 8 81 81 81 81 81 8| 8/8L 81 8L 81 81 81/ 81

Step by Step Solution

3.50 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

Heres how to create a database diagram 1Launch the Relationships Window 2Show any Queries andor Orph... 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_2

Step: 3

blur-text-image_3

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

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Marketing questions