Question

You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram and the accompanying document should identify keys, constraints, entity types, relationship types, specialisation/generalisation if any, etc

i. The ER diagram should include, among others, representative attributes for all entity types, proper subclassing if any, and correct participation multiplicities for the relationship types. It should be meaningfully and well designed, and should also include all relevant and necessary aspects, and indicate any supplementary business rules if you decide to introduce.

ii. Map the above ER diagram into a global relation diagram (GRD). All the attributes should be kept there too. Include in the diagram all the primary keys, foreign keys, and the multiplicity constraints.

Need help with question ii the most

Mini Case: An Instant Recruitment System

Instant Recruitment is a system to be designed to recruit casual staff under a very short notice, as well as on a more regular basis. For simplicity, this system will be limited to serving a large school at a university where casual staff need to be recruited for lecturing, tutoring, and marking etc.

Casual staff: Within the school's recruitment database, each candidate for casual staff must provide their contact details in terms of home address, email address and mobile phone number, and must provide an estimated travel time to reach the school from home. Each candidate has to specify a list of subjects they can teach, their relevant years of experience there, and their self-rated competitiveness or preference with the subject in the range of 0 to 10. Each candidate also needs to enlist their qualifications and the positions they are interested for the casual work.

Positions: There can be different type of positions made available to the casuals, according to whether a position is for lecturing, tutoring or marking etc. The casuals are paid on hourly basis according to their positions.

Staff Request: When a casual staff is being requested or sought, it will be associated with a particular position for the payment rate, and the position will specify certain expertise or subjects the casual staff should be familiar with.

Recruitment: Each casual staff is recruited to a specific academic position for a period of time to conduct the teaching activity at a given venue, and will be assigned to a relevant academic supervisor for the academic liaison. For example, a casual staff may be employed to do 4 hours each week for the in-class tutoring during the semester, and this type of recruitment is considered a regular recruitment. For a regular recruitment, a casual staff will be assigned a specific class venue and the number of hours to work there starting from an allocated beginning time. The recruitment will also specify the number of weeks the appointed casual is to conduct the same activity at the same weekly time and venue.

Answer 1

Solution :

I have tried to explain it in very simple language and
I hope that i have answered your question satisfactorily.Leave doubts in comment section if any.