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

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

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Heres how to create a database diagram 1Launch the Relationships Window 2Show any Queries andor Orph... View the full answer