enter command: Dan Crith
enter command: Fancy boy
enter command: John Smith
enter command: John Crith
enter command: Dan Joe
enter command: Joey Liu
enter command: Kristin Lee
enter command: Dan Crith
//this search command didn't find Dan because the 'search name' is exact match query
search command: Dan
Name Address ID GPA Major Salary
//Duplicate names are allowed, search command find all people with name: Dan Crith
search command: Dan Crith
Name Address ID GPA Major Salary
Dan Crith 101 sunset street DANCRITH 3.88 EECS 15:00
Dan Crith 780 PriceFork street DANCRIT1 3.02 CMSC 13:50
//remove people named: Dan Crith
delete command: Dan Crith
search command: Dan Crith
Name Address ID GPA Major Salary
Dan Crith 780 PriceFork street DANCRIT1 3.02 CMSC 13:50
//search command format 2
search command: 1 3.5
Name Address ID GPA Major Salary
Dan Joe 401 Roanoke street DANJOE01 3.50 ARTC 15.50
//search people whose GPA are between 3.0 and 3.6
search command: 1 3.0 3.6
Name Address ID GPA Major Salary
John Smith 809 WinsorHill street JOHNSMIT 3.02 ICSE 11.50
John Crith 401 Roanoke street JOHNCRIT 3.00 CACS 35.00
Dan Joe 401 Roanoke street DANJOE01 3.50 ARTC 15.50
Dan Crith 780 PriceFork street DANCRIT1 3.02 CMSC 13:50
//remove person whose GPA is 3.50
delete command: 1 3.50
//Dan Joe was removed
search command: 1 3.0 3.6
Name Address ID GPA Major Salary
John Smith 809 WinsorHill street JOHNSMIT 3.02 ICSE 11.50
John Crith 401 Roanoke street JOHNCRIT 3.00 CACS 35.00
Dan Crith 780 PriceFork street DANCRIT1 3.02 CMSC 13:50
//search people who major in EECS
search command: EECS
Name Address ID GPA Major Salary
Joey Liu 111 College avenue JOEYLIU2 3.83 EECS 15.00
delete command: EECS
search command: EECS
Name Address ID GPA Major Salary
//range search
search command: 2 C D
Name Address ID GPA Major Salary
Fancy boy 507 CountryClub street FANCYBOY 2.88 CSEE 25.00
John Crith 401 roanoke street JOHNCRIT 3.00 CACS 35.00
Dan Crith 780 PriceFork street DANCRIT1 3.02 CMSC 13:50
//Empty the all records (BSTs, HashTable, file)
make null command
//No one should be found because the records are clear
search command: 1 0.0 4.0
Name Address ID GPA Major Salary
//enter error, GPA should be smaller than or equal to 4.0
enter command: Dan Crith
error: GPA is greater than 4.0
//Correct this time
enter command: Dan Crith
//Dan Crith is still in the database!
search command: Dan Crith
Name Address ID GPA Major Salary
Dan Crith 101 sunset street DANCRITH 3.88 EECS 15:00
//search error, lower bound is bigger than upper bound
search command: 1 3.0 2.0
error: lower bound is greater than upper bound