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.
18th Century Merchant
www.18thcenturymerchant.com
Database Purpose:
Develop a system to allow for bridal registrants to sign-up for
newsletters and email alerts - to request a bridal registry listing
in the main website.
Core Functions include:
• Sign-up for bridal registry email and newsletters
• Newsletter generator and customer relations management for
email blasts to specified customer groups or individuals.
TNCN News Channel
www.tncn.tv
Database Purpose:
Create a website application that plays current news clips from
the Associated Press and allow for insertion of paid advertisements
into the video window display.
Core Functions include:
• API integration with Associated Press to populate the website
with news videos.
• System also allows the administrator to insert advertising
to auto-play at the front of each news video.
Charlie Laurens and Associates
www.charlielaurens.com
Database Purpose:
Provide a way to automate the storage of real estate documents and
to allow retrieval of documents online for clients.
Core Functions include:
• Develop software application to upload client documents
to local hard drives and virtual storage in tandem.
• Provide unique secure client login access to view
real estate documents and transactions.
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.
IES - Integrated Electric Services
DNN Database Purpose:
Create a user friendly CMS system in Dot Net Nuke (DNN) to control
HTML and Flash files for IES - Integrated Electrical Services, Inc.
(www.ies-co.com)
Core Functions include:
• Zip code search , Search by map and complete control of text,
HTML navigation and images.
HRBiz4Sale - Hampton Roads Businesses for Sale
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.
|
