Reference no: EM133218215

The Career Advising Center at a University would like a "Career Advising Website" to be created so they can better manage the student requests for career advising appointments. The Career Advising Center would like to assign appropriate Industry Advisors with students based on career area.

Every Industry Advisor has an area (or areas) of expertise, that is, they are knowledgeable in providing career advice for particular career areas (e.g. Arts, Education, Engineering, Healthcare, Marketing, etc...)

Students come to the Career Advising Center to get career advice in a particular career area. Students who log into the system will have a profile with their basic information - first name, last name, studentID, phone number, email and a career area which they select from a list of career areas.

Industry Advisors also have their basic information - first name, last name, facultyID, office location, phone, email, and area(s) of expertise (area of expertise taken from the same list of career areas the Students have.)

Let's assume each student is interested in only one career area (e.g. Engineering) whereas Industry Advisors can have more than one career area listed as their areas of expertise.

Students can request an advising session and based on their career area an appropriate Industry Advisor will be assigned.

An advising session will be scheduled between the student and an Industry Advisor at a specific date and time, in a particular location (either Room 100, Room 200, or Room 300), and for a specific career area (for example, to indicate this advising session is to discuss the Engineering career area.) At the end of the advising session the student has the opportunity to rate their experience with a simple numeric rating (e.g. 1 to 10) and a free-form text box.

At various times, the Career Advising Center would want to gather information about the number of advising sessions that took place, the number of advising sessions that took place per career area, the total number of unique students who requested advising sessions (students can request multiple advising sessions during an academic year), the average rating given, or the Industry Advisor who was rated the highest, etc.

Make an E-R diagram for the database scenario. Make sure to include an indication of the cardinality of relationships and specify any mandatory relationship (total participation). State any assumptions that you make.

Convert the E-R diagram to tables, using schema statements.