Practicum 2

Read the following scenario carefully before answering Questions A and B.

Highline University, like many colleges and universities in the Pacific Northwest (see the Wikipedia article on Pacific Northwest), is accredited by the Northwest Commission on Colleges and Universities (NWCUU-see the NWCCU Web site). Like all the colleges and universities accredited by the NWCCU. Highline University must be reaccredited at approximately accredited five -year intervals. Additionally, the NWCCU requires annual status update reports.

Highline University is made up of five colleges: the College of Business, the college of Social Sciences and Humanities, the College of Performing Arts, the College of Sciences and Technology and the College of Environmental Sciences. Jan Smathers is the president of Highline University, and Dennis Enderby is the provost (a provost is a vice president of academics: the dean of the colleges report to the provost). Highline University is a fictional university and should not be confused with Highline Community College located in Des Moines, Washington. Any resemblance between Highline University and Highline community College is unintentional and purely coincidental.

The college is looking for a data management solution to track students, advisers, and mentors. Additionally. Highline University needs to track alumni because the program administrators view alumni as potential mentors. Moreover the following are some of the policies and procedures associated with the case.

At Highlinc University, all students are required to live on campus and arc assigned Highline University ID numbers and email accounts in the format FirstName.LasrName@students.hu.edu. 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

FirstName, LastName@huedu. 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 FirstName.LastName@somewhere.com.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 FirsName.LastName@companyname.com. 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.

Each student is assigned one and only one faculty adviser and must have an adviser. One faculty member may advise several students, but faculty members are not required to advise students. Only the fact of this assignment is to be recorded in the data model-not possible related data (such as the date the adviser was assigned to the student).

Each student may be assigned one and only one mentor. But students are net required to have a mentor. One mentor may mentor several students, and a person may be listed as a mentor before he or she is assigned students to mentor. Only the fact of this assignment is to be recorded in the data model-not possible related data (such as the date the mentor was assigned to the student).

Each mentor is assigned to work and coordinate with one and only one faculty member, and each mentor must work with a faculty member. One faculty member may work with several faculty mentors. Only the fact of this assignment is to be recorded in the data model-not possible related data (such as the date the faculty member was assigned to the mentor)

Each mentor may be an alumnus, but mentors are not required to be alumni. Alumni cannot, of course, be required to become mentors.

Provide answers for the following questions.

SLO 1

Question: A. Prepare a high level data requirement specification for the case.

Please provide:

i. The important data items for the case.

ii. The relationships among the data items.

iii. Detailed descriptions of each data item.

Then, use a Word document to complete this assignment and upload it here.

Ensure that you use the Select File (File Upload1) option to submit Question A.

SLO 2

Question B: Prepare a data model for the Highline University Mentor Program Information System (MPIS). Use the E-R diagrams. Identify entities and create relationships between entities based on the above facts. Justify the decisions you make regarding minimum and maximum cardinalities.

Please make sure to use a modeling tool such as Oracle Data Modeler or another similar tool to complete your diagram. After finishing, upload a screenshot of your model using the link below.

Ensure that you use the Select File (File Upload) option to submit Question B.

WRITE MY PAPER

Comments

Leave a Reply Cancel reply