Nt1310 Unit 4 Student Information System
Databases are used for record keeping and tracking of information institutions like colleges or organizations (Coronel & Morris, 2015). In this case, the database will be used to keep track of the students・attendance, performance and the courses they are supposed to be taking. This will help the college analyze how the students perform and which classes they least or most attend. The database will also help the college keep track of all the subjects which the student is taking or is expected to take in during the course. Instructors will also be part of the database. The database will track their performance in various subjects and their attendance in each class. The database will be upgraded at the beginning of every subject where each student will confirm their attendance for the particular subject and whether the instructor is in class as well. After an examination, all the students・performance will be
…show more content…
The rules help in shaping and providing the best database program that the college will use. One of the business rules is that the database will only be accessed by the database administrator or the heads of department. This way, students and instructors will not be able to alter any information without seeking for permission first. Results from the database will also be trusted because they are based on true facts that have taken place thought the course (Halpin& Morgan, 2008). The second rule is that all entities should understand their roles in the college. Departments will be responsible for offering courses. Classes will be generated based on the course. Instructors will be expected to teach the students in class. The students will be expected to learn from the instructor and perform well. Once all entities have known their roles, it will be easy to maintain and work with the database. Everybody will be expected to play their part to ensure that the college produces good
The rules help in shaping and providing the best database program that the college will use. One of the business rules is that the database will only be accessed by the database administrator or the heads of department. This way, students and instructors will not be able to alter any information without seeking for permission first. Results from the database will also be trusted because they are based on true facts that have taken place thought the course (Halpin& Morgan, 2008). The second rule is that all entities should understand their roles in the college. Departments will be responsible for offering courses. Classes will be generated based on the course. Instructors will be expected to teach the students in class. The students will be expected to learn from the instructor and perform well. Once all entities have known their roles, it will be easy to maintain and work with the database. Everybody will be expected to play their part to ensure that the college produces good