Answered step by step
Verified Expert Solution
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?
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...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