A college needs a database that supports its placement office to help college students finding out potential employers. The primary purpose of the database is to schedule interviews and facilitate searches by students and companies. The requirements are the followings:

Student data include a unique identifier, a name, phone number, an email address, a web address, a major, a minor, and a GPA.

The placement office maintains a standard list of positions based on the Labor Department's list of occupations. Position data include a unique position identifier and a position description.

Company data include a unique company identifier, a company name, and a list of positions and interviewers. Each company must map its positions into the position list maintained by the placement office. For each available position, the company lists the cities in which positions are available.

Interviewer data include a unique interviewer identifier, a name, a phone, an email address, and a web address. Each interviewer works for one company.

An interview includes a unique interview identifier, a date, a time, a location (building and room), an interviewer, and a student.

An interview may be setup without knowing the interviewer

An interview is setup with the student Draw the E/R diagram using IE notation for the database.

This E/R diagram should include entities, relationships, attributes, and constraints. You need to specify primary keys and foreign keys for all entities. You also need to specify the rationale for your design.