Sunshine State University Project / Database - this was a major project accomplished over three months by a group of 25 people divided into three teams: Interface Team, Database Team, and QA Team. The goal was to create an operable scholarship awards portal to keep track of awards offered and received, and the students and faculty involved, as well as any outstanding awards. As a member of the database team I was assigned the tasks of normalization, SQL table creation, query development, and assisting the QA team with testing. To portray the interaction of the database tables and the query results, I created a testing web site and uploaded it and the database to a dedicated server. The web site was created in ASP.Net / SQL 2008 and was used to present the database to the Top Management Team. This is the link to the web site. Please feel free to use this web site as it was only made for testing the database and records are not used by anyone. Be sure to enter a student before the student applies for an award, and/or enter an award before it is given - due to foreign key restraints.
Relevant Visual Basic Code - included in this document is the code for inserting and updating the database tables.
ERD Normalization - given the ERD from other members of the team our task was to bring the ERD to third normal form, as is best practice in ERD normalization. This was done with James Clarke, a San Diego State Information Systems graduate.
Database Tables - from the normalized ERD, we created tables for MS SQL 2008. These tables were designed, then created on the SQL server. This was done with James Clarke, a San Diego State Information Systems graduate.
Database Queries - these queries were created according to system specifications. They range from simple queries to complex joins. They are displayed on the Queries page of the web site in corresponding order.