Last two pictures are Homework #6, which continues off of Homework #5, the first
ID: 3728049 • Letter: L
Question
Last two pictures are Homework #6, which continues off of Homework #5, the first five pictures. Both Homework #5 and #6 should make one single program at the end. I apologize in advance if it's a long assignment, but I really need help on both homeworks. So I'd appreciate the help, thank you!
General Description: For this program you are tasked with writing a program which stores database of the information for Students, Faculty, and Staff at a local university The program will make use of inheritance and polymorphism. Please used hw5 for the package name The Person Class .A person has e first name e last name o email address o Address and one or more PhoneNumbers (NOTE: A person can have any number of phone numbers, so design this class accordingly) The Address Class .An address has street number optional apartment number e street name e city e state © zip code The PhoneNumber Class A phone number has o type (cell phone, home phone, business, etc...) o an area code o a prefix SuffiExplanation / Answer
package hw6;
import java.util.ArrayList;
public class Person {
private String firstname;
private String lastname;
private String emailaddress;
private Address address;
private ArrayList<PhoneNumber> number;
public Person() {}
public String getFirstname() {
return firstname;
}
public void setFirstname(String firstname) {
this.firstname = firstname;
}
public String getLastname() {
return lastname;
}
public void setLastname(String lastname) {
this.lastname = lastname;
}
public String getEmailaddress() {
return emailaddress;
}
public void setEmailaddress(String emailaddress) {
this.emailaddress = emailaddress;
}
public Address getAddress() {
return address;
}
public void setAddress(Address address) {
this.address = address;
}
public ArrayList<PhoneNumber> getNumber() {
return number;
}
public void setNumber(ArrayList<PhoneNumber> number) {
this.number = number;
}
public String toString() {
String s;
s= "Name: " + firstname + " " +lastname + " " + address + " Email: " + emailaddress + " "+"Phone: ";
for(int i = 0; i< number.size(); i++) {
PhoneNumber num = number.get(i);
s += num +" ";
}
return s;
}}
package hw6;
public class Address {
private int streetNumber;
private String optionalApartmentNumber;
private String streetName;
private String city;
private String state;
private int zipCode;
public int getStreetNumber() {
return streetNumber;
}
public void setStreetNumber(int streetNumber) {
this.streetNumber = streetNumber;
}
public String getOptionalApartmentNumber() {
return optionalApartmentNumber;
}
public void setOptionalApartmentNumber(String string) {
this.optionalApartmentNumber = string;}
public String getStreetName() {
return streetName;
}
public void setStreetName(String streetName) {
this.streetName = streetName;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public int getZipCode() {
return zipCode;
}
public void setZipCode(int zipCode) {
this.zipCode = zipCode;
}
public String toString() {
String s5="";
if(optionalApartmentNumber!=null) {
s5 = "Address: " + streetNumber + " " + streetName + " "+
" " + optionalApartmentNumber + " " + city + ", " + state + ", " + zipCode;
return s5;
}
if(optionalApartmentNumber == null) {
s5 = "Address: " + streetNumber + " " + streetName + " "+
" " + city + ", " + state + ", " + zipCode;
return s5;
}
return s5;
}
}
package hw6;
public class PhoneNumber {
private String type;
private int areaCode;
private int prefix;
private int suffix;
public PhoneNumber() {}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public int getAreaCode() {
return areaCode;
}
public void setAreaCode(int areaCode) {
this.areaCode = areaCode;
}
public int getPrefix() {
return prefix;
}
public void setPrefix(int prefix) {
this.prefix = prefix;
}
public int getSuffix() {
return suffix;
}
public void setSuffix(int suffix) {
this.suffix = suffix;
}
public String toString() {
String s1;
s1 = "" + type + ": " + " (" + areaCode + ") " + prefix + " - " + suffix;
return s1;
}
}
package hw6;
public class Employee extends Person {
private String location;
private double salary;
public String getLocation() {
return location;
}
public void setLocation(String location) {
this.location = location;
}
public double getSalary() {
return salary;
}
public void setSalary(double salary) {
this.salary = salary;
}
@Override
public String toString() {
String s2 = super.toString();
s2 = s2 + "Office Location: " + location + " " +
"Salary: " + salary + " ";
return s2;
}
}
package hw6;
public class Faculty extends Employee {
String officeHours;
String rank;
public String getOfficeHours() {
return officeHours;
}
public void setOfficeHours(String officeHours) {
this.officeHours = officeHours;
}
public String getRank() {
return rank;
}
public void setRank(String rank) {
this.rank = rank;
}
@Override
public String toString() {
String s3;
s3 = super.toString();
s3 += "Office Hours: " + officeHours + " " +
"Rank: " + rank + " ";
return s3;
}
}
package hw6;
public class Staff extends Employee{
String jobTitle;
public String getJobTitle() {
return jobTitle;
}
public void setJobTitle(String jobTitle) {
this.jobTitle = jobTitle;
}
@Override
public String toString() {
String s4;
s4 = super.toString();
s4+= "Job Title: " + jobTitle + " ";
return s4;
}
}
package hw6;
public class Student extends Person {
String classStanding;
public String getClassStanding() {
return classStanding;
}
public void setClassStanding(String classStanding) {
this.classStanding = classStanding;
}
@Override
public String toString() {
String string = super.toString();
string += "Class Standing: " + classStanding + " ";
return string;
}
}
package hw6;
import java.util.ArrayList;
public class Database {
private static ArrayList<Person> per = new ArrayList<>();
public Database(ArrayList<Person> per) {
this.per = per;
}
public static void printDatabase(){
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
System.out.println("(" +(i+1)+")." +" " +person);
}
}
public void printDatabase(String occupation) {
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
//person.getClass() method returns class object of person(which is Person).
//getSimpleName() method returns the name of class such as Student,Faculty, Employee, and Staff.
if(person.getClass().getSimpleName().equalsIgnoreCase(occupation)) {
System.out.println(person);
}
}
}
public static int getNumberOfPeople() {
return per.size();
}
public static int getNumberOfStudents() {
int count = 0;
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person.getClass().getSimpleName().equalsIgnoreCase("Student")) {
count++;
}
}
return count;
}
public static int getNumberOfEmployees() {
int count = 0;
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person.getClass().getSimpleName().equalsIgnoreCase("employee")) {
count++;
}
}
return count;
}
public static int getNumberOfStaff() {
int count = 0;
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person.getClass().getSimpleName().equalsIgnoreCase("staff")) {
count++;
}
}
return count;
}
public static int getNumberOfFaculty() {
int count = 0;
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person.getClass().getSimpleName().equalsIgnoreCase("faculty")) {
count++;
}
}
return count;
}
public static int getNumberOfStudentsByClassStanding(String standing) {
int count = 0;
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person.getClass().getSimpleName().equalsIgnoreCase("student")) {
//casting person to refer to the Student class and thus access the methods in that class.
if(((Student) person).getClassStanding().equalsIgnoreCase(standing)) {
count++;
}
}}
return count;
}
public static void displayEmployeesGreaterThanSalary(double salary ) {
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
//check whether the object person is an instance of the Employee class.
if(person instanceof Employee) {
//Casting the person object to enable it to access getSalary method in Employee class.
if(((Employee) person).getSalary()>salary) {
System.out.println(person);
}
}
}
}
public static void displayEmployeesEqualToSalary(double salary) {
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person instanceof Employee) {
if(((Employee) person).getSalary() == salary) {
System.out.println(person);
}
}
}
}
public static void displayEmployeesLessThanSalary(double salary) {
for(int i =0; i<per.size();i++) {
Person person = per.get(i);
if(person instanceof Employee) {
if(((Employee) person).getSalary()<salary) {
System.out.println(person);
}
}
}
}
public ArrayList<Person> getPer() {
return per;
}
public void setPer(ArrayList<Person> per) {
this.per = per;
}
}
package hw6;
import java.util.ArrayList;
public class Testrun {
public static void main(String[] args) {
ArrayList<Person> listOfPeople=new ArrayList<Person>();
Student student1=new Student();
student1.setFirstname("Stephnie");
student1.setLastname("Khan");
student1.setEmailaddress("SteKhan@mail.com");
student1.setClassStanding("freshman");
PhoneNumber ph_one=new PhoneNumber();
ph_one.setAreaCode(626);
ph_one.setType("Home");
ph_one.setPrefix(322);
ph_one.setSuffix(6532);
PhoneNumber ph_two=new PhoneNumber();
ph_two.setAreaCode(815);
ph_two.setType("Mobile");
ph_two.setPrefix(774);
ph_two.setSuffix(1212);
ArrayList<PhoneNumber> phones=new ArrayList<PhoneNumber>();
phones.add(ph_one);
phones.add(ph_two);
student1.setNumber(phones);
Student student2=new Student();
student2.setFirstname("Ken");
student2.setLastname("Chen");
student2.setEmailaddress("kman@mail.com");
student2.setClassStanding("junior");
PhoneNumber ph_three=new PhoneNumber();
ph_three.setAreaCode(626);
ph_three.setType("Mobile");
ph_three.setPrefix(789);
ph_three.setSuffix(2345);
ArrayList<PhoneNumber> phones2=new ArrayList<PhoneNumber>();
phones2.add(ph_three);
student2.setNumber(phones2);
Staff staff1=new Staff();
staff1.setFirstname("Jennifer");
staff1.setLastname("Mach");
staff1.setEmailaddress("jennychinchin@mail.com");
staff1.setSalary(5000);
staff1.setJobTitle("Vice President");
PhoneNumber sph_one=new PhoneNumber();
sph_one.setAreaCode(626);
sph_one.setType("Mobile");
sph_one.setPrefix(757);
sph_one.setSuffix(2223);
PhoneNumber sph_two=new PhoneNumber();
sph_two.setAreaCode(626);
sph_two.setType("Mobile");
sph_two.setPrefix(663);
sph_two.setSuffix(3222);
ArrayList<PhoneNumber> sphones=new ArrayList<PhoneNumber>();
sphones.add(sph_one);
sphones.add(sph_two);
staff1.setNumber(sphones);
Staff staff2=new Staff();
staff2.setFirstname("Loren");
staff2.setLastname("Chen");
staff2.setEmailaddress("Lchen@mail.com");
staff2.setSalary(6000);
staff2.setJobTitle("Administrator");
PhoneNumber s2ph_one=new PhoneNumber();
s2ph_one.setAreaCode(583);
s2ph_one.setType("Home");
s2ph_one.setPrefix(202);
s2ph_one.setSuffix(314);
PhoneNumber s2ph_two=new PhoneNumber();
s2ph_two.setAreaCode(111);
s2ph_two.setType("Mobile");
s2ph_two.setPrefix(334);
s2ph_two.setSuffix(334);
ArrayList<PhoneNumber> s2phones=new ArrayList<PhoneNumber>();
s2phones.add(s2ph_one);
s2phones.add(s2ph_two);
staff2.setNumber(s2phones);
Faculty faculty = new Faculty();
faculty.setFirstname("Zac");
faculty.setLastname("You");
faculty.setEmailaddress("zac1@csula.com");
faculty.setSalary(4000);
faculty.setRank("#11");
faculty.setOfficeHours("M,W,F, 1:50PM-3:05PM");
faculty.setLocation("CSULA");
PhoneNumber ph_4=new PhoneNumber();
ph_4.setAreaCode(345);
ph_4.setType("Mobile");
ph_4.setPrefix(111);
ph_4.setSuffix(111);
ArrayList<PhoneNumber> phones41=new ArrayList<PhoneNumber>();
phones41.add(ph_4);
faculty.setNumber(phones41);
Employee emp = new Employee();
emp.setFirstname("Keenan");
emp.setLastname("Wang");
emp.setEmailaddress("Knnena@gamil.com");
emp.setSalary(3000.0);
emp.setLocation("UCLA");
PhoneNumber ph_5=new PhoneNumber();
ph_5.setAreaCode(626);
ph_5.setType("Mobile");
ph_5.setPrefix(123);
ph_5.setSuffix(111);
ArrayList<PhoneNumber> phones4=new ArrayList<PhoneNumber>();
PhoneNumber ph_6 = new PhoneNumber();
ph_6.setAreaCode(728);
ph_6.setPrefix(111);
ph_6.setSuffix(112);
ph_6.setType("Home");
phones4.add(ph_5);
phones4.add(ph_6);
emp.setNumber(phones4);
Address ad1=new Address();
ad1.setStreetNumber(112);
ad1.setCity("Las Vegas");
ad1.setState("NV");
ad1.setOptionalApartmentNumber("A1333");
ad1.setStreetName("Washington Ave");
ad1.setZipCode(644443);
Address ad2=new Address();
ad2.setStreetNumber(999);
ad2.setCity("Los Angeles");
ad2.setState("CA");
ad2.setOptionalApartmentNumber("777");
ad2.setStreetName("Peck Road");
ad2.setZipCode(91755);
Address ad3=new Address();
ad3.setStreetNumber(555);
ad3.setCity("Monterey Park");
ad3.setState("CA");
ad3.setOptionalApartmentNumber("D");
ad3.setStreetName("Alhambra Ave");
ad3.setZipCode(91755);
Address ad4=new Address();
ad4.setStreetNumber(673);
ad4.setCity("Hollywood");
ad4.setState("CA");
ad4.setOptionalApartmentNumber("AP-12");
ad4.setStreetName("Hollywood Dr.");
ad4.setZipCode(90076);
Address ad5 = new Address();
ad5.setStreetNumber(14209);
ad5.setCity("Baldwin Park");
ad5.setStreetName("Riverside St.");
ad5.setZipCode(91706);
ad5.setState("CA");
student1.setAddress(ad1);
student2.setAddress(ad2);
staff1.setAddress(ad3);
staff2.setAddress(ad4);
faculty.setAddress(ad5);
emp.setAddress(ad5);
listOfPeople.add(student1);
listOfPeople.add(student2);
listOfPeople.add(staff1);
listOfPeople.add(staff2);
listOfPeople.add(faculty);
listOfPeople.add(emp);
Database database=new Database(listOfPeople);
System.out.println("Displaying all the people: ");
database.printDatabase();
System.out.println(" Displaying all the staff members: ");
database.printDatabase("staff");
System.out.println(" Displaying all the students: ");
database.printDatabase("student");
System.out.println(" Displaying all the facultys: ");
database.printDatabase("faculty");
System.out.println(" Displaying all the employees: ");
database.printDatabase("employee");
System.out.println(" Displaying all members with salary equal to 4000: ");
database.displayEmployeesEqualToSalary(4000);
System.out.println(" Displaying all members with salary less than 4000: ");
database.displayEmployeesLessThanSalary(4000);
System.out.println(" Displaying all members with salary greater than 4000: ");
database.displayEmployeesGreaterThanSalary(4000);
System.out.println(" ");
System.out.println("Total number of people: " + database.getNumberOfPeople());
System.out.println("Number of employees: "+database.getNumberOfEmployees());
System.out.println("Numbetr of faculty: "+database.getNumberOfFaculty());
System.out.println("Number of staff: "+database.getNumberOfStaff());
System.out.println("Number of students: "+database.getNumberOfStudents());
System.out.println("Number of freshman: "+database.getNumberOfStudentsByClassStanding("freshman"));
System.out.println("Number of Sophmore: "+database.getNumberOfStudentsByClassStanding("sophmore"));
System.out.println("Number of Junior: "+database.getNumberOfStudentsByClassStanding("Junior"));
System.out.println("Number of Senior: "+database.getNumberOfStudentsByClassStanding("senior"));
//Using file
FileHelper.readFile("data.csv");
ArrayList<Person> persons=FileHelper.createObjects();
for (Person person : persons) {
if(person!=null)
System.out.println(person.toString()+" ");
}
}}
package hw6;
import java.io.File;
import java.io.IOException;
import java.nio.charset.Charset;
import java.nio.file.Files;
import java.util.ArrayList;
public class FileHelper {
static ArrayList<String> data = new ArrayList<>();
// Read the file
public static void readFile(String filename) {
try {
data = (ArrayList<String>) Files.readAllLines(new File("./" + filename).toPath(), Charset.defaultCharset());
System.out.println(data);
} catch (IOException e) {
e.printStackTrace();
}
}
public static ArrayList<Person> createObjects() {
ArrayList<Person> persons = new ArrayList<>();
// first get the whole data
// parse data to objects and add to list of people
// first we need to identify object type and then create object accordingly
int index = 0;
do {
String string = data.get(index);
if (string.contains("Student")) {
// create a student object
// read first line and split using ,
String arr[] = string.split(",");
Student student = new Student();
student.setFirstname(arr[1]);
student.setLastname(arr[2]);
// create address object
Address add = new Address();
add.setStreetNumber(Integer.parseInt(arr[3]));
add.setOptionalApartmentNumber(arr[4]);
add.setStreetName(arr[5]);
add.setState(arr[6]);
add.setCity(arr[7]);
add.setZipCode(Integer.parseInt(arr[8]));
student.setEmailaddress(arr[9]);
student.setClassStanding(arr[10]);
student.setAddress(add);
// create phone objects
String s = null;
index++;
ArrayList<PhoneNumber> numbers = new ArrayList<>();
do {
s = data.get(index);
if ((s.contains("Staff") || s.contains("Faculty") || s.contains("Student"))) {
break;
}
String array[] = s.split(",");
PhoneNumber phone = new PhoneNumber();
phone.setAreaCode(Integer.parseInt(array[2]));
phone.setType(array[1]);
phone.setPrefix(Integer.parseInt(array[3]));
phone.setSuffix(Integer.parseInt(array[4]));
numbers.add(phone);
index++;
} while (data.size() >index);
student.setNumber(numbers);
persons.add(student);
} else if (string.contains("Faculty")) {
// create a student object
// read first line and split using ,
String arr[] = string.split(",");
Faculty faculty = new Faculty();
faculty.setFirstname(arr[1]);
faculty.setLastname(arr[2]);
// create address object
Address add = new Address();
add.setStreetNumber(Integer.parseInt(arr[3]));
add.setOptionalApartmentNumber(arr[4]);
add.setStreetName(arr[5]);
add.setState(arr[6]);
add.setCity(arr[7]);
add.setZipCode(Integer.parseInt(arr[8]));
faculty.setEmailaddress(arr[9]);
faculty.setLocation(arr[10]);
faculty.setSalary(Double.parseDouble(arr[11]));
faculty.setOfficeHours(arr[12]);
faculty.setRank(arr[13]);
faculty.setAddress(add);
// create phone objects
String s = null;
index++;
ArrayList<PhoneNumber> numbers = new ArrayList<>();
do {
s = data.get(index);
if ((s.contains("Staff") || s.contains("Faculty") || s.contains("Student"))) {
break;
}
String array[] = s.split(",");
PhoneNumber phone = new PhoneNumber();
phone.setAreaCode(Integer.parseInt(array[2]));
phone.setType(array[1]);
phone.setPrefix(Integer.parseInt(array[3]));
phone.setSuffix(Integer.parseInt(array[4]));
numbers.add(phone);
index++;
} while (data.size() >index);
faculty.setNumber(numbers);
persons.add(faculty);
} else if (string.contains("Staff")) {
// create a student object
// read first line and split using ,
String arr[] = string.split(",");
Staff staff = new Staff();
staff.setFirstname(arr[1]);
staff.setLastname(arr[2]);
// create address object
Address add = new Address();
add.setStreetNumber(Integer.parseInt(arr[3]));
add.setOptionalApartmentNumber(arr[4]);
add.setStreetName(arr[5]);
add.setState(arr[6]);
add.setCity(arr[7]);
add.setZipCode(Integer.parseInt(arr[8]));
staff.setEmailaddress(arr[9]);
staff.setLocation(arr[10]);
staff.setSalary(Double.parseDouble(arr[11]));
staff.setJobTitle(arr[12]);
staff.setAddress(add);
// create phone objects
String s = null;
index++;
ArrayList<PhoneNumber> numbers = new ArrayList<>();
do {
s = data.get(index);
if ((s.contains("Staff") || s.contains("Faculty") || s.contains("Student"))) {
break;
}
String array[] = s.split(",");
PhoneNumber phone = new PhoneNumber();
phone.setAreaCode(Integer.parseInt(array[2]));
phone.setType(array[1]);
phone.setPrefix(Integer.parseInt(array[3]));
phone.setSuffix(Integer.parseInt(array[4]));
numbers.add(phone);
index++;
} while (data.size() >index);
staff.setNumber(numbers);
persons.add(staff);
}
} while (data.size() >index);
return persons;
}
}
output
Displaying all the people:
(1).
Name: Stephnie Khan
Address: 112 Washington Ave
A1333 Las Vegas, NV, 644443
Email: SteKhan@mail.com
Phone:
Home: (626) 322 - 6532
Mobile: (815) 774 - 1212
Class Standing: freshman
(2).
Name: Ken Chen
Address: 999 Peck Road
777 Los Angeles, CA, 91755
Email: kman@mail.com
Phone:
Mobile: (626) 789 - 2345
Class Standing: junior
(3).
Name: Jennifer Mach
Address: 555 Alhambra Ave
D Monterey Park, CA, 91755
Email: jennychinchin@mail.com
Phone:
Mobile: (626) 757 - 2223
Mobile: (626) 663 - 3222
Office Location: null
Salary: 5000.0
Job Title: Vice President
(4).
Name: Loren Chen
Address: 673 Hollywood Dr.
AP-12 Hollywood, CA, 90076
Email: Lchen@mail.com
Phone:
Home: (583) 202 - 314
Mobile: (111) 334 - 334
Office Location: null
Salary: 6000.0
Job Title: Administrator
(5).
Name: Zac You
Address: 14209 Riverside St.
Baldwin Park, CA, 91706
Email: zac1@csula.com
Phone:
Mobile: (345) 111 - 111
Office Location: CSULA
Salary: 4000.0
Office Hours: M,W,F, 1:50PM-3:05PM
Rank: #11
(6).
Name: Keenan Wang
Address: 14209 Riverside St.
Baldwin Park, CA, 91706
Email: Knnena@gamil.com
Phone:
Mobile: (626) 123 - 111
Home: (728) 111 - 112
Office Location: UCLA
Salary: 3000.0
Displaying all the staff members:
Name: Jennifer Mach
Address: 555 Alhambra Ave
D Monterey Park, CA, 91755
Email: jennychinchin@mail.com
Phone:
Mobile: (626) 757 - 2223
Mobile: (626) 663 - 3222
Office Location: null
Salary: 5000.0
Job Title: Vice President
Name: Loren Chen
Address: 673 Hollywood Dr.
AP-12 Hollywood, CA, 90076
Email: Lchen@mail.com
Phone:
Home: (583) 202 - 314
Mobile: (111) 334 - 334
Office Location: null
Salary: 6000.0
Job Title: Administrator
Displaying all the students:
Name: Stephnie Khan
Address: 112 Washington Ave
A1333 Las Vegas, NV, 644443
Email: SteKhan@mail.com
Phone:
Home: (626) 322 - 6532
Mobile: (815) 774 - 1212
Class Standing: freshman
Name: Ken Chen
Address: 999 Peck Road
777 Los Angeles, CA, 91755
Email: kman@mail.com
Phone:
Mobile: (626) 789 - 2345
Class Standing: junior
Displaying all the facultys:
Name: Zac You
Address: 14209 Riverside St.
Baldwin Park, CA, 91706
Email: zac1@csula.com
Phone:
Mobile: (345) 111 - 111
Office Location: CSULA
Salary: 4000.0
Office Hours: M,W,F, 1:50PM-3:05PM
Rank: #11
Displaying all the employees:
Name: Keenan Wang
Address: 14209 Riverside St.
Baldwin Park, CA, 91706
Email: Knnena@gamil.com
Phone:
Mobile: (626) 123 - 111
Home: (728) 111 - 112
Office Location: UCLA
Salary: 3000.0
Displaying all members with salary equal to 4000:
Name: Zac You
Address: 14209 Riverside St.
Baldwin Park, CA, 91706
Email: zac1@csula.com
Phone:
Mobile: (345) 111 - 111
Office Location: CSULA
Salary: 4000.0
Office Hours: M,W,F, 1:50PM-3:05PM
Rank: #11
Displaying all members with salary less than 4000:
Name: Keenan Wang
Address: 14209 Riverside St.
Baldwin Park, CA, 91706
Email: Knnena@gamil.com
Phone:
Mobile: (626) 123 - 111
Home: (728) 111 - 112
Office Location: UCLA
Salary: 3000.0
Displaying all members with salary greater than 4000:
Name: Jennifer Mach
Address: 555 Alhambra Ave
D Monterey Park, CA, 91755
Email: jennychinchin@mail.com
Phone:
Mobile: (626) 757 - 2223
Mobile: (626) 663 - 3222
Office Location: null
Salary: 5000.0
Job Title: Vice President
Name: Loren Chen
Address: 673 Hollywood Dr.
AP-12 Hollywood, CA, 90076
Email: Lchen@mail.com
Phone:
Home: (583) 202 - 314
Mobile: (111) 334 - 334
Office Location: null
Salary: 6000.0
Job Title: Administrator
Total number of people: 6
Number of employees: 1
Numbetr of faculty: 1
Number of staff: 2
Number of students: 2
Number of freshman: 1
Number of Sophmore: 0
Number of Junior: 1
Number of Senior: 0
[Student,Jack,Smith,117,-1,Sunshine Dr.,Los Angeles,CA,90012,jsmith@school.edu,freshman, Phone,Cell,555,555,5555, Phone,Home,777,777,7777, Faculty,Jack,Smith,117,21,Sunshine Dr.,Los Angeles,CA,90012,jsmith@school.edu,E&T-310,40000,M/W 1-2 T/TH 3-4,Full Time, Phone,Cell,555,555,5555, Phone,Home,777,777,7777, Phone,Work,888,888,8888, Staff,Jack,Smith,117,15,Sunshine Dr.,Los Angeles,CA,90012,jsmith@school.edu,E&T-310,30000,Computer Science Administrative Assistant, Phone,Cell,555,555,5555]
Name: Jack Smith
Address: 117 Sunshine Dr.
-1 CA, Los Angeles, 90012
Email: jsmith@school.edu
Phone:
Cell: (555) 555 - 5555
Home: (777) 777 - 7777
Class Standing: freshman
Name: Jack Smith
Address: 117 Sunshine Dr.
21 CA, Los Angeles, 90012
Email: jsmith@school.edu
Phone:
Cell: (555) 555 - 5555
Home: (777) 777 - 7777
Work: (888) 888 - 8888
Office Location: E&T-310
Salary: 40000.0
Office Hours: M/W 1-2 T/TH 3-4
Rank: Full Time
Name: Jack Smith
Address: 117 Sunshine Dr.
15 CA, Los Angeles, 90012
Email: jsmith@school.edu
Phone:
Cell: (555) 555 - 5555
Office Location: E&T-310
Salary: 30000.0
Job Title: Computer Science Administrative Assistant
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.