Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 an Admissions representative,
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 creates 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 sections, 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.
According to the Course Registration Scenario content above, create a threat model of the scenario.
Create Data Flow Diagram (DFD) and analyze them using STRIDE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

Why We Form Relationships Managing Relationship Dynamics?

Answered: 1 week ago