Manage Information of Northampton Business School Essay

Manage Information of Northampton Business School - Essay Example From the report it is clear that  the database making process has been developed considering not only the problem of reduced attendance of the students but will also provide an overall view of the factors that is contributing to the reduced rate of attendance in Northampton Business School.   The database management process will be based on the relationships and attributes reflected in the Entity Relationship Model. The relationship model of the Department reflects the overall scenario that leads to the students and their attributes whereas the relationship model of students specifically focuses on the information required by the University for assessing the factors leading to the growing numbers of absentees among the students.  This discussion stresses that  the entities identified in both the relationship models are having direct or indirect relationships with the students monitoring process. Considering the overall view as provided in the relationship model with departmen t view, the entities are department, faculty, students and course whereas the specific student relationship model reflects only two entities namely, students and courses. The relationship between the entities is mostly defined by the purpose served by each entity.  The primary and foreign keys in the created models have been marked with multicoloured attributes to reflect them clearly.  The primary keys in both the models are the id numbers of the courses and the students.