A summary of business activities for registering courses for enrolled students and for registering class lists for faculty members and for administrators at an online university is as follows:

• Please keep the full text of the question as part of your answering sheet.
• Be as clear and objective as you can in all questions and be sure you are answering what is asked.
• Justify all your numerical answers and answer all the questions using your own words.
  Show all your work, including how you found your answer (this is very important and essential
  to have your answer graded appropriately!).

The Book is: Systems Analysis and Design (9th Edition) Kenneth E. Kendall Julie E. Kendall

Question 1:

A summary of business activities for registering courses for enrolled students and
for registering class lists for faculty members and for administrators at an online university is as follows:

Students send in a course registration form consisting of their personal information and their desired courses. The system checks that the courses are available and that the student is academically qualified to take the course.
Based on the checking results, the system will send to the student a confirmation and/or rejection letter with detailed information for each requesting course. Faculty members and administrators will receive registering class lists when the registration period is complete.

Draw the logical data flow diagram level 0 for the “Courses Registration” system showing all the major processes using the following “recommended” items:

Process names:

(1) Check Course Availability and Academic Qualification

(2) Register Requesting Courses

(3) Confirm/Reject Courses Registration

(4) Generate Class List

Data stores: Derived from the above narrative

External entities: Derived from the above narrative

Data flows: Derived from the above narrative.

Question 2:

Create an ERD for the reservations system that consists of four entities: Passenger, Agent, Reservation, and Flight by doing the followings:

1. Identify reasonable relationships (one-to-one, one-to-many, or many-to-many)
   among these four entities. (8 points)
2. Write sentences explaining the left-to-right and right-to-left relationships
   for each relationship. (8 points)

***Note that either a passenger or an agent could make a flight reservation in
this system.

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"