显示实体间一对一关系的报告 – 在本报告中，一个变量与另一个变量之间存在相互依存关系。例如，学号将与学生成绩挂钩。这将是为各个学生根据出勤记录获得数据而产生的报告的一对一基础，并且随后进行相应的修改。
显示实体之间的一对多关系的报告 – 在这个输入的实体中，将以与其相关的其他实体的形式显示该实体的完整数据库。例如，学生证可以显示学生姓名，出勤记录，成绩和其他实体。这将与各个变量或与单一实体在各个方面相联系的实体建立很大的联系和联系。
显示许多实体关系的报告 – 这是许多实体与许多其他实体的关联或链接。例如，我们需要关于安东尼（Cole，2009）这个名字的学生姓名的出勤和等级数据。
显示实体之间多对一关系的报表 – 这些报表中的许多实体在输入系统时将提供一个特定实体的数据。例如，学生姓名，身份证，成绩将给予学生在特定班级或课程中获得的分数。
Give four examples of the types of reports that could be produced for Northampton Business School using this small database, showing clearly the layout of each with data included and specifically the purpose of each. Clearly state the benefits of your reports for the management decision making. Ensure you produce reports that will help all levels of management.
Relational Database is actually forming an association or the relationship among the various entities that are available in the database. There are various kinds of reports that could be created from a relational database:
Reports in which one to one relationship of entities is shown – In this report there would be interdependence of one variable on another one. For example student ID will be linked to student Grade. This will be one to one basis of the reports that are generated for the various students to obtain the data based on their attendance records and later modified accordingly.
Reports in which one to many relationship of entities is shown – In this one entity being entered would reveal complete database of the entity in terms of other entities linked to it. For example student ID would reveal student name, his attendance record, grade and other entities. This will establish a great link and association with that of the various variables or the entities linked with the one single entity on all fronts.
Reports in which many too many relationship of entities is shown – This is association or linking of many entities with many other entities. For example we need data of attendance and grade with respect to the names of the student with the name Anthony (Cole, 2009).
Reports in which many to one relationship of entities are shown – These are the reports in which many entities when input into the system will give the data of one specific entity. For example student name, id, grade will give the marks obtained by the student in that specific class or the course.