Question

Design a role-based access control system. Thank you. Will leave a great rating

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 transcripts of grades. Faculty advisers can inspect transcripts 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.

Your solution must have

-A schematic of the role-hierarchy

-A tabular explanation of each role, and the permissions it has.

Answer 1

Abovie is the role based access schema for the system

Schematic representation of role hiearchy below

Roles and thier permission

University Administration	creates course registration
Course registration	create subroles,
HR	recruits faculty
Admission representative	admit students
Student	select course
Faculty	inspect transcript
Course
Course section	selects course
Department chairs	creates course section
Database	enforce grades
Grade
Transcript
Register office	creates transcript