Database Example

Interactive Text Equivalent

The following example database is sorted based on the search criteria given below:

LAST NAME FIRST NAME CLASS HOMETOWN BIRTH MONTH GENDER
Smith John Freshman Macon August Male
Turner Evelyn Freshman Brunswick April Female
Arndale Carrie Sophomore Atlanta September Female
Zwemke Jason Freshman Cartersville May Male
Lane Penny Sophomore Decatur September Female
Guoqing Yu Freshman Augusta April Male
Jones John Junior Waycross December Male
Vasser Pricilla Freshman Blue Ridge February Female
Wright Mandy Freshman Rome September Female

Single set of criteria

Sort according to Class, Freshman

LAST NAME FIRST NAME CLASS HOMETOWN BIRTH MONTH GENDER
Smith John Freshman Macon August Male
Turner Evelyn Freshman Brunswick April Female
Guoqing Yu Freshman Augusta April Male
Zwemke Jason Freshman Cartersville May Male
Vasser Pricilla Freshman Blue Ridge February Female
Wright Mandy Freshman Rome September Female
Jones John Junior Waycross December Male
Arndale Carrie Sophomore Atlanta September Female
Lane Penny Sophomore Decatur September Female

Search according to Birth Month, April

LAST NAME FIRST NAME CLASS HOMETOWN BIRTH MONTH GENDER
Turner Evelyn Freshman Brunswick April Female
Guoqing Yu Freshman Augusta April Male
Smith John Freshman Macon August Male
Jones John Junior Waycross December Male
Vasser Pricilla Freshman Blue Ridge February Female
Zwemke Jason Freshman Cartersville May Male
Wright Mandy Freshman Rome September Female
Arndale Carrie Sophomore Atlanta September Female
Lane Penny Sophomore Decatur September Female

Search according to Gender, Female

LAST NAME FIRST NAME CLASS HOMETOWN BIRTH MONTH GENDER
Turner Evelyn Freshman Brunswick April Female
Vasser Pricilla Freshman Blue Ridge February Female
Wright Mandy Freshman Rome September Female
Arndale Carrie Sophomore Atlanta September Female
Lane Penny Sophomore Decatur September Female
Guoqing Yu Freshman Augusta April Male
Smith John Freshman Macon August Male
Jones John Junior Waycross December Male
Zwemke Jason Freshman Cartersville May Male

Two sets of criteria

Search according to Gender - Male / Class - Freshman

LAST NAME FIRST NAME CLASS HOMETOWN BIRTH MONTH GENDER
Guoqing Yu Freshman Augusta April Male
Smith John Freshman Macon August Male
Zwemke Jason Freshman Cartersville May Male
Jones John Junior Waycross December Male
Turner Evelyn Freshman Brunswick April Female
Vasser Pricilla Freshman Blue Ridge February Female
Wright Mandy Freshman Rome September Female
Arndale Carrie Sophomore Atlanta September Female
Lane Penny Sophomore Decatur September Female

Search according to Birth Month - September / Class Sophomore

LAST NAME FIRST NAME CLASS HOMETOWN BIRTH MONTH GENDER
Arndale Carrie Sophomore Atlanta September Female
Lane Penny Sophomore Decatur September Female
Wright Mandy Freshman Rome September Female
Zwemke Jason Freshman Cartersville May Male
Vasser Pricilla Freshman Blue Ridge February Female
Jones John Junior Waycross December Male
Smith John Freshman Macon August Male
Guoqing Yu Freshman Augusta April Male
Turner Evelyn Freshman Brunswick April Female