B. Alex Bridges CPSC-101, Winter 1998 The Database Reporter Program --ENTIRE DATABASE AS ENTERED-- Entry #0 => Name = 'Abbot, Paul' => Social Security Number = '123-45-6789' => Department = 'ME' => Title = 'PROFESSOR' => Salary = '123456.78' Entry #1 => Name = 'Chase, Chevy' => Student Number = '581-26-9437' => Major = 'BCS' => WAG = '100.000' => Graduation Date = 'WI/99' Entry #2 => Name = 'Zufus, Steve' => Social Security Number = '750-42-5741' => Department = 'ECE' => Title = 'DEPARTMENT HEAD' => Salary = '000019.99' Entry #3 => Name = 'Spade, David' => Student Number = '835-11-8142' => Major = 'BME' => WAG = '087.194' => Graduation Date = 'SP/02' Entry #4 => Name = 'Martin, Steve' => Social Security Number = '261-42-0314' => Department = 'CPSC' => Title = 'SECRETARY' => Salary = '026879.41' Entry #5 => Name = 'Patrick, Stewart' => Student Number = '999-88-7777' => Major = 'BCE' => WAG = '095.842' => Graduation Date = 'SM/03' Entry #6 => Name = 'McNeal, Bill' => Social Security Number = '141-81-7182' => Department = 'PHYS' => Title = 'PROFESSOR' => Salary = '000000.02' Entry #7 => Name = 'Caine, Michael' => Student Number = '015-19-3480' => Major = 'BME' => WAG = '065.000' => Graduation Date = 'FA/05' Entry #8 => Name = 'Simpson, Homer' => Social Security Number = '625-98-0001' => Department = 'CHEM' => Title = 'DEPARTMENT CHAIR' => Salary = '005428.39' Entry #9 => Name = 'Akroyd, Dan' => Student Number = '344-56-2471' => Major = 'BAM' => WAG = '074.615' => Graduation Date = 'WI/98' Entry #10 => Name = 'Candy, John' => Social Security Number = '471-31-5142' => Department = 'CPSC' => Title = 'PROFESSOR' => Salary = '036000.00' Entry #11 => Name = 'Harrison, Ford' => Student Number = '626-22-6475' => Major = 'BME' => WAG = '091.254' => Graduation Date = 'SP/98' Entry #12 => Name = 'Spiner, Brent' => Social Security Number = '918-63-7495' => Department = 'ECE' => Title = 'PROFESSOR' => Salary = '099999.99' Entry #13 => Name = 'Murphy, Eddie' => Student Number = '444-22-6666' => Major = 'BAM' => WAG = '077.505' => Graduation Date = 'SM/99' Entry #14 => Name = 'Lee, Bruce' => Social Security Number = '864-14-7181' => Department = 'CPSC' => Title = 'PROFESSOR' => Salary = '018525.50' Entry #15 => Name = 'Connery, Sean' => Student Number = '777-11-2414' => Major = 'BAM' => WAG = '084.514' => Graduation Date = 'FA/00' --ENTIRE DATABASE SORTED BY NAME-- Entry #0 => Name = 'Abbot, Paul' => Social Security Number = '123-45-6789' => Department = 'ME' => Title = 'PROFESSOR' => Salary = '123456.78' Entry #1 => Name = 'Akroyd, Dan' => Student Number = '344-56-2471' => Major = 'BAM' => WAG = '074.615' => Graduation Date = 'WI/98' Entry #2 => Name = 'Caine, Michael' => Student Number = '015-19-3480' => Major = 'BME' => WAG = '065.000' => Graduation Date = 'FA/05' Entry #3 => Name = 'Candy, John' => Social Security Number = '471-31-5142' => Department = 'CPSC' => Title = 'PROFESSOR' => Salary = '036000.00' Entry #4 => Name = 'Chase, Chevy' => Student Number = '581-26-9437' => Major = 'BCS' => WAG = '100.000' => Graduation Date = 'WI/99' Entry #5 => Name = 'Connery, Sean' => Student Number = '777-11-2414' => Major = 'BAM' => WAG = '084.514' => Graduation Date = 'FA/00' Entry #6 => Name = 'Harrison, Ford' => Student Number = '626-22-6475' => Major = 'BME' => WAG = '091.254' => Graduation Date = 'SP/98' Entry #7 => Name = 'Lee, Bruce' => Social Security Number = '864-14-7181' => Department = 'CPSC' => Title = 'PROFESSOR' => Salary = '018525.50' Entry #8 => Name = 'Martin, Steve' => Social Security Number = '261-42-0314' => Department = 'CPSC' => Title = 'SECRETARY' => Salary = '026879.41' Entry #9 => Name = 'McNeal, Bill' => Social Security Number = '141-81-7182' => Department = 'PHYS' => Title = 'PROFESSOR' => Salary = '000000.02' Entry #10 => Name = 'Murphy, Eddie' => Student Number = '444-22-6666' => Major = 'BAM' => WAG = '077.505' => Graduation Date = 'SM/99' Entry #11 => Name = 'Patrick, Stewart' => Student Number = '999-88-7777' => Major = 'BCE' => WAG = '095.842' => Graduation Date = 'SM/03' Entry #12 => Name = 'Simpson, Homer' => Social Security Number = '625-98-0001' => Department = 'CHEM' => Title = 'DEPARTMENT CHAIR' => Salary = '005428.39' Entry #13 => Name = 'Spade, David' => Student Number = '835-11-8142' => Major = 'BME' => WAG = '087.194' => Graduation Date = 'SP/02' Entry #14 => Name = 'Spiner, Brent' => Social Security Number = '918-63-7495' => Department = 'ECE' => Title = 'PROFESSOR' => Salary = '099999.99' Entry #15 => Name = 'Zufus, Steve' => Social Security Number = '750-42-5741' => Department = 'ECE' => Title = 'DEPARTMENT HEAD' => Salary = '000019.99' --FACULTY SORTED BY DEPARTMENT, THEN NAME-- Entry #8 => Department = 'CHEM' => Name = 'Simpson, Homer' => Social Security Number = '625-98-0001' => Title = 'DEPARTMENT CHAIR' => Salary = '005428.39' Entry #9 => Department = 'CPSC' => Name = 'Candy, John' => Social Security Number = '471-31-5142' => Title = 'PROFESSOR' => Salary = '036000.00' Entry #10 => Department = 'CPSC' => Name = 'Lee, Bruce' => Social Security Number = '864-14-7181' => Title = 'PROFESSOR' => Salary = '018525.50' Entry #11 => Department = 'CPSC' => Name = 'Martin, Steve' => Social Security Number = '261-42-0314' => Title = 'SECRETARY' => Salary = '026879.41' Entry #12 => Department = 'ECE' => Name = 'Spiner, Brent' => Social Security Number = '918-63-7495' => Title = 'PROFESSOR' => Salary = '099999.99' Entry #13 => Department = 'ECE' => Name = 'Zufus, Steve' => Social Security Number = '750-42-5741' => Title = 'DEPARTMENT HEAD' => Salary = '000019.99' Entry #14 => Department = 'ME' => Name = 'Abbot, Paul' => Social Security Number = '123-45-6789' => Title = 'PROFESSOR' => Salary = '123456.78' Entry #15 => Department = 'PHYS' => Name = 'McNeal, Bill' => Social Security Number = '141-81-7182' => Title = 'PROFESSOR' => Salary = '000000.02' --STUDENTS SORTED BY WAG-- Entry #0 => WAG = '065.000' => Name = 'Caine, Michael' => Student Number = '015-19-3480' => Major = 'BME' => Graduation Date = 'FA/05' Entry #1 => WAG = '074.615' => Name = 'Akroyd, Dan' => Student Number = '344-56-2471' => Major = 'BAM' => Graduation Date = 'WI/98' Entry #2 => WAG = '077.505' => Name = 'Murphy, Eddie' => Student Number = '444-22-6666' => Major = 'BAM' => Graduation Date = 'SM/99' Entry #3 => WAG = '084.514' => Name = 'Connery, Sean' => Student Number = '777-11-2414' => Major = 'BAM' => Graduation Date = 'FA/00' Entry #4 => WAG = '087.194' => Name = 'Spade, David' => Student Number = '835-11-8142' => Major = 'BME' => Graduation Date = 'SP/02' Entry #5 => WAG = '091.254' => Name = 'Harrison, Ford' => Student Number = '626-22-6475' => Major = 'BME' => Graduation Date = 'SP/98' Entry #6 => WAG = '095.842' => Name = 'Patrick, Stewart' => Student Number = '999-88-7777' => Major = 'BCE' => Graduation Date = 'SM/03' Entry #7 => WAG = '100.000' => Name = 'Chase, Chevy' => Student Number = '581-26-9437' => Major = 'BCS' => Graduation Date = 'WI/99'