Database for Managing Orders for a Flooring Company

(A) Description: Build a database for managing orders for a flooring company. The database needs to be accessible by multiple users online or through a share-point.

(B) Access to database: Employees will need to have log-in details to access the database. Some employees will have restricted access to certain parts of the database. The administrator should be able to sign up relevant employees, give them their log-in credentials and determine their access rights.

(C) Overview of work flow:
When a new work order is sent by the customer as a PDF attachment via email, the surveyor goes on site to undertake a survey and uploads a photograph, description of the issue and the size of the room unto the database. A cost quote is prepared for the work based on the information on the database and sent to the client for approval on the client’s software. Once the work order is approved, the customer sends an email to the company and the job can be done. Once the job has been completed, the installer uploads a photo of the completed job and percentage of completion before marking it as completed on the database. A payment application is made on the client’s software, the client sends a payment notice showing how much is payable, an invoice is submitted through a separate software and the invoiced amount is paid.

I have attached full specification in PDF format for you to review.