Database Design

In this project, you are asked to design a database to support the recruitment of casual staff for a school. The major business requirements are summarised below in the Mini Case: Instant Recruitment. 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. The ER diagram and the accompanying document should identify keys, constraints, entity types, relationship types, specialisation/generalisation, etc. The ER diagram should in general have more than 5 entity or relationship types and no more than 15. This means that students will have to selectively identify those most important entity types and relationship types for their work and for the fulfillment of the key business functionalities. More concretely, your deliverables should include THE ATTACHED FILE HAS THE FULL PROJECT SPECIFICATIONS, HINTS, AND REQUIREMENTS. IT IS NOT VERY HARD AND SHOULD NOT TAKE TO LONG. I NEED IT WITHIN 2 DAYS. THANK YOU.