Manage Information of Northampton Business School Essay

Manage Information of Northampton Business School - screen ExampleFrom the report it is clear thatthe database making process has been developed considering not only the problem of minify attendance of the students but will also provide an overall view of the factors that is contributing to the reduced post of attendance in Northampton Business School. The database management process will be based on the kinds and attributes reflected in the Entity Relationship Model. The blood 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 knowledge required by the University for assessing the factors leading to the growing numbers of absentees among the students.This discussion stresses thatthe entities identified in both the relationship models are having direct or indirect relationships with the students monitoring process. Considering the overall view as provided i n the relationship model with department 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 opposed 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.