Scribd
Upload
4 views1 page

Enrollment System Improvements Summary

The document summarizes improvements made to an application between demonstration and submission dates. Key updates include: 1) Allowing editing of final grades in enrollment records; 2) Sorting enrollments in descending order by final grade; 3) Checking for duplicate students when updating records; 4) Displaying error messages if duplicate course IDs, names or prerequisites are entered; 5) Ensuring student and course IDs are linked correctly between tables; 6) Completing three reporting features: a student's course list, a course's student list, and a list of students failing at least one course.

Uploaded by

Zack Zack
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

Enrollment System Improvements Summary

The document summarizes improvements made to an application between demonstration and submission dates. Key updates include: 1) Allowing editing of final grades in enrollment records; 2) Sorting enrollments in descending order by final grade; 3) Checking for duplicate students when updating records; 4) Displaying error messages if duplicate course IDs, names or prerequisites are entered; 5) Ensuring student and course IDs are linked correctly between tables; 6) Completing three reporting features: a student's course list, a course's student list, and a list of students failing at least one course.

Uploaded by

Zack Zack
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

6.

Improvement
From the demonstration date to submission date:
1. Update the final grade of an enrolment record.
Previously, the application did not support user to make change to the final grade.
We have updated it. Currently, user can edit the final grade and save the change. We
have designed the interface so that the user can only make change to the final grade,
not any other field of the enrolment record.
2. Sort enrolment
We had mistake in display the enrolment in descending order. The order was not in
the order as required. We have fixed the bugs so enrolment now is sorted in
descending order of the final grade.
3. Update student
Our program previously can not check if user is already existed when updating
information of student.
We have designed the update student interface with student id can not be changed
as student id is unique.
4. Manage course
- In the demonstration date, we can not check if the course name and prerequisites
are already existed or not, we have update the code. Our application now will display
an error message if user enters existed course id or course name or prerequisites.
- We have design the update course interface so now course id can not be edited by
user, so we do not have to check if course is already existed when updating course.
5. Relation between student, course and enrolment
- We have update the code so student id in student table is the student field in
enrolment and course id in course table is the course field in the enrolment.
6. Report
- In the previous demonstration date, we have not finished the report. Now, we have
finished the three requirements:
+ Display a list of course of a given student: In the student list interface, each student
is assigned to a link. When user click a link corresponding to the student, a web page
is generated with a table listing all courses of that student. The course information
includes course id, course name and prerequisites.
+ Display all student of a given course: Each course in course list is assign with a link.
When user click on the link of a course, a web page is generated with a table
containing all students enrolled in that course.
+ Display a list of student who have failed at least one course: In the enrolment list,
we designed a button, if user click on that button, a web page is generated with a
table listing all students that have failed at least one course. The table contains
student’s information: student id, first name, last name, address, birthday.
7.

You might also like