About selected scenario
We have selected the 2nd scenario as our case study topic. The sample scenario what we selected is, Scenario 2 : An academic institute in your town wants to set up a database to record details about its staff, and the departments they belong to. They intend to record the following information. For each member of staff, their staff identity number, name, job title, and salary, for each department, its name and address, and for each member of st aff, all departments that they belong to. It is required that every member of staff belongs to at least one department. For each department, there is a head of department. It is required that each department has exactly one head of department. Develop a sy stem to manage the day - to - day business of this institute . Above scenario guide us to develop a system to manage the day-to-day business of the academic institute.