A course registration system is a computer system used by the university’s administration to plan courses, for students to register for courses, and for faculty to grade them.
Students and faculty can only enroll or teach a class if they have been recorded in the registration system. Students are entered into the system by and Admissions representatives; faculty members by a Human Resources employee. For all persons, their university ID number, last name, first name, date of birth, and username is recorded. Usernames must be unique (no username may be allocated to more than one person at a time).
Before students can enroll for a course, the course needs to be created. Each course is identified by a course number (up to 7 characters), a course name, credits awarded, and a cap. The cap represents the largest number of students that should be enrolled in the course, and must be greater than zero. Courses are created by faculty.
When the university’s administration decides to offer a course, a department chair create a course section. Department chairs are faculty members who have been given additional duties. The course section always refers to a single course, and has a course section identifier (3 characters) and a term in which it is offered. The faculty member who is assigned to teach the course is also recorded with the section.
When students start enrolling for a course, they must search for available sections and choose one. Students may only register once for each course in a given term, but if a course is offered in multiple section, the system must be able to track which students are enrolled in each section.
Faculty can grade courses. Each student can only receive one grade for each term in which they take a course. When grades are recorded, the registration system must record who issued the grade, and when it was issued. The database must enforce that only valid grades can be assigned. Valid grades include F (fail), D- through A+, and I (incomplete).
The Registrar’s Office can create transcriipts of grades. Faculty advisers can inspect transcriipts and enrollments for student advising.
Assignment
Design a role-based access control system to support this case study. Clearly identify roles, role hierarchies, and permissions.
You may work in groups of at most two people.
Your solution must be a written report, consisting of:
1) A title page, include the name of group members, the title of the assignment, the course number and course name, and the due date.
2) A schematic of the role-hierarchy
3) A tabular explanation of each role, and the permissions it has.
