This is an example of the Mid Valley auto database. This database stores and manages auto listings for a dealership. This is just an example so it only has a page that lists all of the current listings and has a form for adding new listings. The full application uploads and manages multiple images for each listing and has administrative features for updating and deleting. The database used for this application contains all of the tables necessary for managing auto listings for a dealership to put their inventory online. The application uses Java Server Pages and a PostgreSQL or MySQL database. Java form beans are used for handling data securely and AJAX is used for filling in the form with information from the database as the user selects different options on the form such as selecting Acura or BMW will bring up a listing of models to select. (Continue Reading)

The Secret Shopper application and database was designed for secret shoppers to post evaluations online so that reps and store owners could access site evaluations electronically. The application is written with PHP and SQL and uses a MySQL database. Access is restricted and secured using JavaScript and 128bit encryption algorithms. You can access a prototype version of this application by clicking on the image and entering guest for username and guest for password. The database is fairly complex for a small application like this. AJAX is used to fill in certain forms so people do not need to enter information to post evaluations. An image of the database logical model is included below. (Continue Reading)

Game Tagg was a group project where I worked with a team of three people. The purpose of the project was to create a social bookmarking website prototype for videogames. The application uses JSP to send data to and receive data from a Java program that makes and executes SQL statements to interact with a PostgreSQL database. The project was somewhat large for a basic prototype with over 35 pages and 11 database tables. The different pages used to auto redirect such as when clicking on user home and logging in previously it would automatically go back to user home. This functionality was removed because of web host issues, and registration and everything has been changed to be completely open so users can test out everything.   (Continue Reading)