Pseudo Code:

rset QueryDatabase(String query);

rset UpdateDatabase(String query);

-User Account Creation Pseudo Code

boolean CheckPassword(Password1, Password2) {

If (Password1 = Password2)

return true;

else

return false;

}

void StoreUserInfo(LegalFirstName, LegalLastName, MI, DOB, Email, Password1, Password2) {

if(CheckPassword(Password1, Password2)){

query = “INSERT INTO AuthData(UserName, Password, Legal_FName, Legal_LName, Legal_MI, DOB) VALUES (“ + Email + “, “ + Password1 + “, “ + LegalFirstName + “, “ +LegalLastName + “, “ + MI + “, “ + DOB + “)”;

UpdateDatabase(query);

}

}

-User Account Deletion Pseudo Code

void DeleteUser(UserID){

query = “DELETE FROM AuthData WHERE UserID =”+UserID;

UpdateDatabase(query);

}

-Profile Creation Pseudo Code

void StoreProfileInfo(UserID, Nickname, CityOfBirth, HospitalOfBirth, Hometown, Gender, CurrentLocation, Address, ContactEmail, ContactPhone, IMScreenName, HighSchool, PostHighSchool, PersonalInfo, PictureLocation) {

query = “INSERT INTO GBProfile(UserID, Nickname, PlaceOfBirth, HospitalOfBirth, Hometown, Address, Gender, CurrentLocation, HighSchool, Post HS, ContactEmail, ContactPhone, IMName, AboutMe, Picture) VALUES (“ + UserID + “, “ + Nickname + “, “ + CityOfBirth + “, “ + HospitalOfBirth + “, “ + Hometown + “, “ + Address + “, “ + Gender + “, “ + CurrentLocation + “, “ + HighSchool + “, “ + PostHighSchool + “, “ + ContactEmail + “, “ + ContactPhone + “, “ + IMScreenName + “, “ + PersonalInfo + “, “ + PictureLocation + “)”;

UpdateDatabase(query);

}