Updated 08/16/07
Since early 2005, I have been developing a student record system for a small college that is currently in use but not fully deployed due to unexpected administrative concerns. It is now being used successfully to maintain student personal data, transfer credits, course credit, and to produce transcripts and grade reports by the main campus registrar. Several additional queries are functional based on past requirements. Additionally it has the ability to maintain instructor personal data, credentials, class rosters, grade entry, and course catalog data for undergraduate and graduate curriculums. Further development and funding has been stopped in 2007 because of unresolved (non-technical) issues concerning access to the database by other faculty and students even with tiered security.
The project is Oracle-based SOA using vb.net and has six locally-networked Oracle clients. There are about a dozen interactive panels that start with screenshots similar to the examples below. These panels (below) are ASP.NET-based and were to be used for web-enabled access from any Internet-connected computer. The programs are quite generic and can easily be customized to another institution. This is far simpler to implement and use than some major "ERP" solutions.
VB.NET and ASP.NET student and faculty panels connecting with Oracle 10g database.
