CASE BACKGROUND

The system we will design is a"Student Registration System" which we have been working on during the first3projects. Re-familiarize yourself with the case by reading the following description of the system carefully before moving on to the following sections:

As the head of information systems of a local college, you have been assigned the task of developing a new student registration system.

The university wants to use a web-based 3-tier system to replace its legacy system that was developed based on mainframe technology.

The new system will allow students to register for courses and view report cards online from personal computers connected to the Internet.

Professors will be able to access the system to sign up for courses that they wish to teach as well as to record student grades.

The new system will allow students to select multiple course offerings for the coming semester. Course offerings will have a maximum of ten students and a minimum of three students.

A course offering with fewer than three students will be canceled. For each semester, there is a period of time during which students can change their schedule. Students must be able to access the system during this time to add/drop courses.

Once the registration process is completed for a student, the registration system sends a note to the billing system. If a course is full during the registration process, the student must be notified of the change before submitting the schedule for processing.

At the end of the semester, the student will be able to view an electronic report card. Since student grades are sensitive information, the system must employ extra security measures to prevent unauthorized access.

Professors will be able to access the online registration system to indicate which courses they will be teaching. They can also see which students signed up for their course offerings.

In addition, the professors will be able to record and post student grades online.?Your task is to conduct the following systems design related activities.

EXERCISES

Your task is to create forms and reports using the skills learned in the lab. For now, we will not worry about authentication and security (i.e., who has access to what). The use case diagram corresponding to the scope of this individual project (IP4) is shown in Figure 1. The dialogue diagram for the "Student Registration System" is shown in Figure 2.

Create the following HTML pages and PHP scripts:

1. The Homepage. Create a static HTML page that links the Current Enrollment report (exercise #5 below) and the list of ?students (exercise #6 below). Name this file index.html. See Figure 3 for a brief sketch.

2. Input Form to Add New Students. Create a PHP script to add a new student to the course registration system. The form should have 2 textboxes for name and studentID and 1 combo box (dropdown) for the new student's major. Also, you need a submit button to submit the form. In order to reduce data input errors (e.g., typos), the combo box for the student's major should only display majors that are currently in the database (i.e., all unique values of the Major field in the Student table).

1 This form should be named formInputStudent.php. The form should send the form data to a controller script called processInputStudent.php which takes the form data and inserts it to the Student table. For now, the controller script (processInputStudent.php) should merely insert the new record (i.e., a new student) and display a confirmation (success or failure), along with links back to the Student List and the Homepage. The sequence diagram for this use case is shown in Figure 4.

3. Edit Form to Edit Current Student Information. Create a PHP script to edit student information. The script should take a studentID as input from the URL as a query string and display the student ID, name and major of that student. If the student for that particular studentID (from the query string) does not exist, the script should display an informative error message (e.g., "ERROR: Student with StudentID ([studentID]) does not exist"2).

If a student with that studentID exists, then the script should display a form with the student's information. The studentID should be displayed but should not be editable. The name and majors should be editable. The current name of the student should be displayed in a textbox and the current major should be displayed in a combo box along with other majors that are possible. In other words, the user (i.e., the registrar) will select the major from the combo box to change it. Name this form formEditStudent.php.

The form should send the form data to a script called processEditStudent.php which takes the form data and updates the Student table. For now, the controller script (processEditStudent.php) should merely update the record and display a confirmation (success or failure), along with links back to the Student List and the Homepage. The sequence diagram for this use case is shown in Figure 5.

4. Course Registration Form. Create a registration form that will select a course to add for a student given a particular student ID (from the query string). If the student for that particular studentID does not exist, the script should display an informative error message (e.g., "ERROR: Student with StudentID ([studentID]) does not exist").

If a student with that studentID exists, then the script should show a dropdown combo box with all courses offered for the "Spring 2017" semester. Obviously, the dropdown should not display the courses in which the student is already registered. The dropdown should display CourseID and Section (e.g., "MGMT5002 (01)"). The registrar3 will select a course and upon submitting the form with the submit button, the student should be registered for this course /section.

Name the form formCourseRegistration.php and the script that processes the form data processCourseRegistration.php. The controller script (processCourseRegistration.php) should insert the new record (i.e., a new schedule) and display a confirmation (success or failure), along with links back to the Student List and the Homepage. The sequence diagram for this use case is shown in Figure 6.

5. Current Enrollment. Create a report showing all courses for the "Spring 2017" semester. The report should list departments first and for each department display a bulleted list of course numbers (e.g., MGMT5001) along with section and number of students in parenthesis. Name this report reportCurrentEnrollment.php. Figure 7 shows the sequence diagram for the current enrollment report and Figure 10 provides a brief sketch of what the report should look like.

This bulleted list should be hyperlinks and when the "course - section (enrollment)" is clicked, this should open a student list for that particular course. If no students are currently enrolled in a particular course, the enrollment figure should show "0". Name the student list script reportCourseEnrollment.php. Figure 8 shows the sequence diagram for the course enrollment report and Figure 11 provides a brief sketch of what the report should look like.

6. List of Students. Display a list of students with the students' ID, name and major in a table. The table should have 5 columns. The first three will be the students' ID, name and major. The fourth column should have a hyperlink to the formEditStudent.php described in exercise

#3. This hyperlink should have the appropriate query string defined so that upon following this hyperlink the student information edit form should be displayed with the correct student information. The text for the hyperlink should be "Click to edit". The fifth column should have a hyperlink to the course registration form described in exercise #4.

This hyperlink should have the appropriate query string defined so that upon following this hyperlink the course registration form for that student should be displayed. The text for this hyperlink should be "Register for Courses". Below the table (i.e., list of students), you should have a link to the form for adding new students as defined in exercise #2. The text for this hyperlink should be "Click Here to Add a New Student". Name this report studentList.php. See Figure 12 for a brief sketch of the student list report.

Attachment:- ip4_assignment_describtion_.rar