Posts

The Entity Relationship Model.

Image
  Introduction to the scenario.   The scenario is about the academic institute.  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 staff, 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 system to manage the day-to-day business of this institute.  Message from the group students. We are group 04 from EEI-3266-WD-E-G11. We are five members in our group. They are, M.Diresh (s92060986), AM.Aroos (s92065965), V.Jemika (s92085752), MM.Zahra (s92085832),S.Sarmijan (s92082608), Y.Yohendran(s92082619). W hat is ER Diagra