All Coast Construction DB
Closed - This job posting has been filled and work has been completed.
I have a construction company that builds and renovates custom homes, and provides savvy property owners, and their managers, high performance commercial tenant improvement from start to finish. They currently keep track of all of the components (appliances, windows, TV’s, sound systems, sinks, carpet, paint, etc.) that go in to the homes they build via an Excel spreadsheet. They want to automate this process and have it be a web based database application which will become a back end function to their current web site. This will be their “Home Inventory” application. This application will require the following …
• We will use MySQL for the database
• The first step of this project will be to establish the tables and their relationships
• We must keep track of the client information and the contents of each room in the house (home inventory) and will look like a combination of the two attachments (Database Fields and 04-Plumbing Fixtures)
• Images of each component and PDF specifications must also be retained.
• They also want to retain a separate table of Manufactures by Category. I feel like that is where the images and PDF files should be stored. The home inventory table would then link to the images and PDF file.
• Both the client and AC admin must login to access the data. The client can only view their home and its contents. The admin will have full edit capabilities and will be responsible for entering all of the data and uploading images and PDF files.
• The AC personnel liked the way the following screen looked for data entry and viewing components … http://3.bp.blogspot.com/-bbfatb0E
• The client should have the capability of searching, viewing, and printing the content by Category (ie. Plumbing fixtures vs. appliances), Room, Item, Manufacture, and Model.
• AC Admin should have the capability of searching, viewing, and printing the content by Building Type, Customer, Category (ie. Plumbing fixtures vs. appliances), Room, Item, Manufacture, and Model.
• The original data will have to be imported from excel spreadsheets and Quick Books.
WE NEED A BALL PARK ESTIMATE OF HOW MANY MAN HOURS YOU THINK IT WILL TAKE TO ACCOMPLISH THIS TASK.
If you have any questions please feel free to contact me. Thanks.