DATABASE CASE STUDIES
 Company
Intranet Development and Web site Security Protection -
Viewing by appointment-consultation only
Database Purpose - Description:
Convert existing html Intranet pages to secured .net web application
Core Functions include:
User Management
Allow super admin to create new users
Allow super admin user to activate/inactivate existing user
Allow super admin user to delete existing user
File Management
Allow super admin user to create and manage folder sections
Implement user friendly form to upload new files
Allow super admin user to delete existing files
Provide Rich Text Editor to add details/instructions for uploaded
files
Allow admin user to create links for external websites
Intranet for Employee
Allow employees to login user their personal credentials (Created
by Super admin)
Allow logged –in user to change password
Allow logged in employee to view/download files
Implement secured file access logic to not to show actual filename/location.
Instead read the file using .net framework and load the file dynamically.
 BGI
Blue Ridge General Construction -
Viewing by appointment-consultation only
Database Purpose - Description:
Project tracking and 'Submittal System' with features for searching,
sorting and detailing information in order to streamline your submittal
entries, editing and work flow. The new system also includes Rich
Text Editor for formatting the comments along with AJAX Spell Checker.
New system is Web based and highly secure..
Core Functions include:
• Login
1. Allow authorized user to login to secured administration section
by entering username and password
2. Allow logged-in user to choose desire location
3. Allow logged-in user to choose desire job
• Administration:
1. Location Management: Allow user to add/edit/delete locations
2. Job Management: Allow user to add/edit/delete jobs and associate
with location
3. Owner Management: Allow user to add/edit/delete owners
4. Architect Management: Allow user to add/edit/delete Architects
5. Sub Contractor Management: Allow user to add/edit/delete subcontractors
6. Implement paging for easy navigation
7. Allow user to search/filter
• Manage Submittals:
1. Implement form to enter submittal details
2. Allow user to create owners and architects from submittals page
3. Allow user to switch between the jobs using quick job selection
option from submittals page
4. Allow user to sort all the columns while entering submittals details
5. Allow user filter columns for easy search
6. Allow user to view/download/print Submittals logs (Subcontractor
log, Log by Sub and so on)
7. Allow user to add additional comments for logs using Rich Text
editor with spell checker
• Manage Transmittals:
1. Implement interface to add/edit/delete transmittals
2. Provide list of already entered transmittals for editing
3. Allow user to create owners and architects from submittals page
4. Provide list of submittals for selection
5. Implement paging for easy navigation
6. Allow user to sort submittals
7. Allow user to filter/search submittals by submittal column properties
8. Provide user friendly interface to enter all details
9. Provide calendar controls to enter date and time
10. Allow user to view view/download/print Transmittal details for
Architects, Owners and Subcontractors
11. Allow user to add additional comments using Rich Text editor with
spell checker
Programming Framework developed in .Net 3.0 and MS SQL 2008
 Independence
Commercial Construction -
Viewing by appointment-consultation only
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 RFP's.
• Bid Invitation: Send specific RFP's
to sub-contractors who have subscribed to the bidding system
 Wibanks
Smith and Thomas
www. wstam.com
Viewing by appointment-consultation only
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: 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.
• Protection and Security: The system prevents
users from copying, saving or recording any on-screen information
displayed.
 Chantel
Ray Team
Database Purpose:
A real estate web application in .Net 3.0/ SQL 2008 DB for the
Real Estate Listings and LMA - Lead Management
Application System.
Core Functions include:
• Keyword search
• Search, post by client, email and details
• Assign follow-up, hot, closed by agent and re-assignments
• Auto listings sign-up
• Result Page:
- Display the search results with listing details and Google map
• Allow user to browse through different pages using .net
AJAX
 Smart
Energy Design Assistance Center
http://360eg.org/
Project Purpose:
Illinois Smart Energy Design Assistance Center's Pre-Qualified
Service Provider directory. Providers users to locate an industry
professional to serve their sustainable needs.
 National
Managers Contract Association
http://www.ncmatysons.org/
Project Purpose:
Complete website design and custom database development.
Core Functions include:
• Event posting and registration sign-up (take payments online)
• Purchase and download whitepapers (take payments online)
• Manage all pages via custom CMS page system
• Integrated mailing list tool
• Chapter Management Search Tool
• Google Map API and Chapter Locater search function
• Integrated Google Search
• Outlook I-CAL export function for events and conference
dates
• Allow user to browse through different pages using .net
AJAX
• Dynamically display events, conferences on multiple pages
 Virginia
Society of Human Resource Management
http://www.vashrm.com
Project Purpose:
Complete website design and custom database development.
Core Functions include:
• Event posting and registration sign-up (take payments online)
• Purchase and download whitepapers (take payments online)
• Chapter and Student Chapter Management Search Tool
• Google Map API and Chapter Locater search function
• Integrated Google Search
• Outlook I-CAL export function for events and conference
dates
• Allow user to browse through different pages using .net
AJAX
• Dynamically display events, conferences on multiple pages
 Chevrolet/
Schawns
Viewing by appointment-consultation only
Project Purpose:
Custom database application for vendor to purchase parts inventory
online; setup profiles for vendor departments and view/recall purchase
histories.
 Charlie
Laurens Portal
Viewing by appointment-consultation only
Project Purpose:
Custom database application that allows for electronic capture
of electronic and paper documents. Super admin. may assign users
login credentials to upload and download access.
 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:
• Client Management: 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.
 South
Hampton Roads Real Estate
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.
|
