Accounting Information System Class

Prepare a prototype database for YNF. Forrest has agreed to provide financial data from his business for the 1st quarter of his fiscal year. That data will be in EXCEL format. You will move the data into Access, structure it appropriately, and set relationships consistent with your data model. Make changes as necessary in file structures to implement efficient tables and eliminate duplication.

Make sure the data are structured appropriately in Access..

orders and sales items 1 order 00 Inventory orders and sales 1 ordere order date customer order_empe sale_date truck_vin 00 customers 9 customer 1 Name purchase GO flower inventory Inventory Flower Name ga purchase flowers items 1 purchase 1 Inventory 00 cash receipts 1 rept customer rept_date 18 18 trucks 1 VIN acquired year make mileage_Jan 12 purchase flowers 1 purchase purchase_date grower nurch mnd employees 1 employees social security.nl Last Name 00 employees_1 employees social security.nl Last_Name first name stores 1 cash disb to growers I check check_date grower cd_empo account check amt 1 Store Phone Address Store Location State Zip Orig.purch_price Acquired_year Life Annual dep | 81 81 payroll I check check_date pay to emp arrunta 00 18 18 growers growere name cash account bank description balance_Jan_01 vendors misc 8 timecards timecard timecard_date reg_time_hours o vendor name purchase misc 1 POS purch date wand orders and sales items 1 order 00 Inventory orders and sales 1 ordere order date customer order_empe sale_date truck_vin 00 customers 9 customer 1 Name purchase GO flower inventory Inventory Flower Name ga purchase flowers items 1 purchase 1 Inventory 00 cash receipts 1 rept customer rept_date 18 18 trucks 1 VIN acquired year make mileage_Jan 12 purchase flowers 1 purchase purchase_date grower nurch mnd employees 1 employees social security.nl Last Name 00 employees_1 employees social security.nl Last_Name first name stores 1 cash disb to growers I check check_date grower cd_empo account check amt 1 Store Phone Address Store Location State Zip Orig.purch_price Acquired_year Life Annual dep | 81 81 payroll I check check_date pay to emp arrunta 00 18 18 growers growere name cash account bank description balance_Jan_01 vendors misc 8 timecards timecard timecard_date reg_time_hours o vendor name purchase misc 1 POS purch date wand