DATABASE CASE STUDIES
 Independence
Commercial Construction -
www.icvgc.com
Database Purpose:
Custom database was developed to improve communication with construction
sub-contractors, field supervisors clients, employees and internal/
book-keeping for accounting proposes.
Core Functions include:
• Daily Construction Reports:
Create database fields for work classification details, Equipment
/Tools used on projects, Equipment Rental item details, Material received
for projects, Upload Photos for site conditions and edit/ add/ delete
change orders and work orders in progress.
• Employee
Login: View employee newsletter, view hours, sick leave, vacation
and comp. time.
• Sub-Contractor Login: Receive and
submit RFP’s and quotations/ view project plans and blueprints
for bidding. Unique sub-contractor's login to submit RFPs.
• Send specific RFPs to sub-contractors who have subscribed
to the bidding system
 Wynne
Residential Corporate Housing - www.wynnecorporatehousing.com
Database Purpose:
Create a web based application whereby users may search corporate
housing and temporary apartments by state and/or metro areas. Also
allow users to also search via an interactive map graphic.
Extend the reach of the website in major search engines.
Core Functions include:
• General and advanced searching
by zip code, state, map search, and nearest miles to apartment/ housing
destination calculations.
• Super admin., may
also add, edit and delete housing locations for live Web display.
• System uses the Google Map API to generate maps
for interactive driving directions and admin. based news/ advertising
management system.
 EMG
Corporation
www. easymoneynow.com
Database Purpose:
Develop a website based display for Easy Money store locations
using spatial geo-data and U.S. zip code database to direct online
users to brick--mortar store locations and/or to apply online for
a cash loan or cash advance.
Core Functions include:
• General and advanced searching by zip code, state, map search,
and nearest miles to store destination calculations. Administrator
may add, edit and delete store locations for live Web display.
• All customer contact information is captured and parsed
into a master CRM database.
 LTD
Hotel and Development Management
www.ltdmanagement.com
Database Purpose:
Develop a website based display showing hotel locations using
spatial geo-data and a US zip code database. Also allow for enhanced
search for hotel amenities and landmarks.
Core Functions include:
• General and advanced searching by zip code, state, map search,
and nearest miles to store destination calculations. Administrator
may add, edit and delete hotel locations and partner advertisement
listings per individual hotel page.
 Wibanks
Smith and Thomas
www. wstam.com
Database Purpose:
Create an online environment for client-investors to view privileged
information. Establish parameters to prevent users from copying
or saving information to their local computers
Core Functions include:
• Three tiered client/member login where depending on the
level of a client’s asset management portfolio participation,
the system allows client’s to access certain documents, articles,
video, PDF and Power Point presentations containing audio/ video.
• The system prevents users from copying, saving or recording
any on-screen information displayed.
 Enspire
Energy
www.enspireenergy.com
Database Purpose:
Developed a system to allow clients to login to their personal/business
energy account(s) to view XLS of documents and daily reports.
Core Functions include:
• Website administrator may create folders/files where users
are assigned secure access to view daily accounts and reports.
Office of Probation for the Norfolk Virginia
District Court
Database Purpose:
Create a highly secure login database for court employees to
update their personal and medical information online using their
global username and password assigned by the district court webmaster.
Core Functions include:
• Detect employee location and department upon login and redirect
to the appropriate online form. User access is integrated with on-site
MS Active server directory of usernames and passwords.
 HRBiz4Sale
- Hampton Roads Businesses for Sale
www.hrbiz4sale.com
Database Purpose:
Create directory style website in .Net 2.0/ SQL 2005 DB to allow
users to sign-up, post and manage business listings (businesses
for sale) in Hampton Roads. Also allow advertisers to sign-up and
purchase advertising on the website.
Core Functions include:
• General and advanced search functions
• Photo, graphic and document uploads
• Website Blog and Calendar
• Quick Hampton Roads locator map
• Mini 'featured' listings on homepage
• Featured random rotation of advertisers.
• Ecommerce integration for advertising customer sign-ups
via Authorize.net.
 South
Hampton Roads Real Estate
www.southhamptonroads.com
Database Purpose:
Create directory style website in .Net 2.0/ SQL 2005 DB to allow
users to sign-up, post and manage real estate listings, service
listings and business listings in Hampton Roads. Also allow advertisers
to sign-up and purchase multiple or 'tiered' advertising programs
on the website.
Core Functions include:
• General and advanced search functions
• Photo, graphic and document uploads
• Advanced search features for finding homes, realtors, builders
and other real estate related services by city and neighborhoods.
• Mini 'featured' listings on homepage
• Featured random rotation of advertisers.
• Ecommerce integration for advertising customer sign-ups
via Authorize.net.
 Smart
Energy Design Assistance Center
http://76.12.106.229/
Database Purpose:
A directory web application in .Net 2.0/ SQL 2005 DB for the
Smart Energy Design Assistance Center to allow users to find pre-qualified
service providers. Users may search the listings using one or more
search criteria.
Core Functions include:
• Keyword search
• Search by Industry
• Search by Categories
• Search by Distance (Zip + Miles)
• Result Page:
- Display the search results with listing details
• Allow user to browse through different pages using .net
AJAX
 Stateside
Associates' iStateLink portal
http://www.stateside.com/iStateLink/login.asp/
Project Purpose:
Visionefx provided re-skinning and graphics to dove-tail with
the creative look of the main Stateside website.
|
