Pine Valley furniture(PVFC) manufacturers high quality wood furniture and distributes it retails within the United States.A single carpenter who kept track of customers by filling invoices in a file cabinet started the company.Today the company has grown to over 70 employees while multiplying in sales volume.Although they no longer use the paper files,they have not yet embraced databases.Most of their invoices are generated using spreadsheet templates.Currently PVFC is split inot 3 locations across the USA.
Pine Valley's Information Technology(IT) infrastructure consists of two full-time employees, a Systems Manager and Network Adminstrator.The systems manager understands that the current filing systems is outdated.
They hired Matrix Data Systems to address Pine Valley Furniture's need of upgrading the current file system.As an employee of Matrix Data System in charge of designing the database,they supplied you with a sample of the customer invoice they use