GoInterns:2010 Fall Database Design

Design

 * The overall design of the GoInterns application is an Model View Controller. The highlighted link can go into further detail regarding this architecture.


 * [[File:Database_design.png]]

Purpsose

 * The GoInterns application has 4 major components, those are:
 * 1) The ability for organizations to add their opportunities to the database.
 * 2) The ability for students to browse/select internships.
 * 3) The ability for an Admin to add/delete students and internship opportunities.
 * 4) The ability for other people to be view reports, but not change data.

Tools Used

 * In order to create the application GoInterns we used the following tools:


 * 1) We used XAMPP,which is a free and open source cross-platform web server package, consisting mainly of the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP and Perl programming languages. All participants in the GoInterns group downloaded and installed a local copy of XAMPP to test and run our application.
 * 2) NetBeansrefers to both a platform framework for Java desktop applications, and an integrated development environment (IDE) for developing with Java, JavaScript, PHP, Python, Ruby, Groovy, C, C++, Scala, Clojure, and others.
 * 3) Staging Server which was supplied to us by the CIS department. Staging server access via VPN was given solely to the IT Manger of every group.  The staging server houses all groups application documents on their perspective folders.  Share-Info

Install Process

 * 1) Initially be sure that XAMPP is locally installed on your local machine. The Windows version is available for download. Also refer to this link for troubleshooting assistance.
 * 2) Copy all files located here. All of these files are needed to run the GoInterns Application successfully.
 * 3) Use the Installation_guide for the next steps involving the gointerns_install.php, which is a SQL script that adds all necessary SQL data to your local machine to use the application successfully.