Database Systems Using Webserver-side Scripting
Management Information System
Information Request Tracking System
Product/Project Description Maintenance System
Coastal Services Center Management Information System (MIS)
The MIS assists CSC allot its
fifteen-plus million dollar budget and nearly one
hundred employees over scores of projects. This
application uses Microsoft SQL Server running on
Microsoft Internet Information Server (IIS) and
creates a web interface using vbscript-powered Active
Server Pages (ASP). Javascript is used to ensure data
entry meets specific criteria, and server-side
processing rechecks before entering data into the MIS
database. This project is an intranet-only site.
Screenshots, in png format
Front Page
General Project Information
Project Personnel
Milestone Edit
Project Review
Milestone Report
Information Request Tracking System (IRTS)
CSC solicits online customer
information on a voluntary basis and the IRTS collects
and reports this information for internal use. The
system both requests information from users who are
downloading products, including email address and
organization type, and reports these variables to the
lead webmaster for yearly reporting. The IRTS is also
used to create mailing labels when past customers
request new products. This site is another MS-SQL
Server driven ASP site, and its reporting capabilities
are intranet-only.
Screenshots, in png format
Front Page
CSS Mailing Labels
Search Constraint Page
Products by State Report
CSC Product/Project Description (PPD) Maintenance System
As products at the Coastal Services
Center became more numerous, a products maintenance
system was created that allowed employees to create
entries for new products as they were being produced
along with the ability to post-date their release on
the external web site. A second level of review was
built in to allow managers to "green-light" entries
and later edits before releasing them to the web.
One major advantage of the system was that the database template was passed through the normal review channels for web design, ensuring the Center-wide, mandated look and feel was utilized, but new products could be added without additional, intra-office review.
Administration page mock-ups (uneditable; for viewing only)
Entry Edit Form
URL and Date Review
Description Edit and Review Page
NCSU CRDM Students Page
As the North Carolina State
University's new Communication and Rhetoric of Digital
Media program added new classes, keeping the students
information page up to date was a headache. This
PHP/MySQL system allowed students to make their own
edits and additions, pushing the maintenance from the
college's webmaster to the system with its
pre-approved template design.
Description of development process for NCSU CRDM student information page
Description Page