Registration Retrieval
Database Type : MySQL
Programming Language : PHP
Source Code

• asks for Registration ID (user_id) for any registrant
• retrievs all the information from the ten tables in the Registration database
• if the registrant is not signed up for any activities, geology trips, etc., prints to the screen that the person is not signed up for such an activity
• prints to the screen the Registration ID (user_id) and names of any accompaniers the registrant may have

Cave Trips Sign-ups
Database Type : MySQL
Programming Language : PHP
Source Code

• asks for Registration ID, First Name, Last Name, first three Cave Trips choices (pull-down menus)
• checks that all fields are entered
• uses First Name and Last Name to check if the person is registered for Convention
• compares the entered Registration ID with the ID found in the database for the person
• checks to make sure that user has not the same trip for at least two of his/her choices
• registers the person for the Cave Trips is preference order if s/he is registered for convention and has entered the correct information
• requests user to fill out additional questionaire if s/he is applying for a Monday, Tuesday, or Wednesday trip

Digital Sessions Sign-ups
Database Type : MySQL
Programming Language : PHP
Source Code

• asks for Registration ID, First Name, Last Name, Desired Session (pull-down menu)
• checks that all fields are entered
• uses First Name and Last Name to check if the person is registered for Convention
• compares the entered Registration ID with the ID found in the database for the person
• dynamically enforces data integrity as users can sign up for both Photoshop sessions, but only one Cartography session
• registers the person for Digital Cartography if s/he meets all the requirements
• if the session is already full, notifies him/her that s/he is on the wait list and will be contacted if a spot opens up

2003 National Speleological Convention's Registration Database
Database Type : MySQL
Original ER Diagram
User Table SQL Script
Registration Table SQL Script
Activities Table SQL Script

SFBC Bariatrics Program Database
Database Type : Oracle 8i
SQL Script for Initial Database Status
* SQL script has been modified to uphold patient confidentiality

Aerosmith Album Database
Database Type : Oracle 8i
* SQL script will be completed and posted on this site in the future!
Original ER Diagram
Excel Sheet of Album Information
SQL Statement Examples

Note::  ER Diagrams by other developers that I critiqued are not for view on this website.