1. Create separate entities for students, alumni, faculty advisers, and mentors.
■ At Highline University, all students are required to live on campus and are assigned Highline University ID numbers and email accounts in the format [email protected]. The student entity should track student last name, student first name, Student University ID number, student email address, dorm name, dorm room number, and dorm phone number.
■ At Highline University, all faculty advisers have on-campus offices and are assigned Highline University ID numbers and email accounts in the format [email protected]. The faculty entity should track faculty last name, faculty first name, Faculty University ID number, faculty email address, department, office building name, office building room number, and office phone number.
■ Highline University alumni live off campus and were previously assigned Highline University ID numbers. Alumni have private email accounts in the format [email protected]. The alumni entity should track alumnus last name, alumnus first name, alumnus former student number, email address, home address, home city, home state, home ZIP code, and phone number.
■ Highline University mentors work for companies and use their company address, phone, and email address for contact information. They do not have Highline University ID numbers as mentors. Email addresses are in the format [email protected]. The mentor entity should track mentor last name, mentor first name, mentor email address, company name, company address, company city, company state, company ZIP code, and company phone number.