The task:
Produce an extended ER diagram, that captures a conceptual design for the information that needs to be kept in a system that manages student work- placements.
Partner organizations register with the university: each partner has name, address, ABN, textual description of the industry it is part of, contact information (name and email) for their student recruitment team lead, and a URL for more information. A partner makes available placement opportunities, which have a name, a text description of the type of work, list of degrees from which students would be chosen for the opportunity, the dates between which the role is available, the minimum number of hours of work a student must do each week,
in the role, and a limit on how many students can be accepted for this placement opportunity. Some opportunities come with a salary, while others are only suited for students who are willing to work without pay.
Students are also users of the system. Each student is required to indicate their SID, name, and email, as well as their degree, their WAM and the year in which they expect to graduate; as well, each student should express interest in some of the available placement opportunities. If a student is interested in a particular opportunity, they should say the earliest date on which they could start, and the last date by which they must be finished.
The University provides information about the different degrees, including name, duration and also contact information for the degree advisor. The system then makes matches between students and opportunities (of course, no student will be matched to an opportunity, unless they had earlier expressed interest in that role); determining the start and end dates for the placement, and also the
number of hours the student will do each week in that role. When a student is allocated to a placement opportunity, an academic supervisor and a partner– based supervisor is also assigned for this placement; different students may have different supervisors, even if they are all allocated to a given opportunity.
Note: you may find this description lacks important details; requests for clarification should be posted on the unit Edstem discussion board, under the posting category of Assignment 2, You should observe closely any answers posted by staff (not only to your own questions, but also to questions from others)