Marist College plans to develop a new Course Registration System to better manage and streamline the online
Fantastic news! We've Found the answer you've been seeking!
Question:
Marist College plans to develop a new ‘Course Registration System’ to better manage and streamline the online registration process for Graduate students. Based on the following requirements create a Use Case, Sequence, Class, ER diagram and sql query for a REGISTRATION REPORT (check Req# 9).
Requirements:
- The system will allow students to register as well as drop both online and ground classes.
- The system will allow the Graduate Director to add/remove/edit courses offered during each semester and set maximum seats availability for each course.
- The system will allow students to view the courses offered for their graduate program during selected semesters.
- The system will also list the pre requirement courses if any associated with a particular course.
- The system should not allow students to register for a course unless the pre-requirement courses have been completed. For Example: A student should not be allowed to register for Systems Design unless s/he has completed its pre-req Information Analysis.
- The system should not allow a student to register for more than 3 courses per semester.
- In case of international students, the system should only allow registration for 1 online course per semester.
- In case of inconsistencies and issues with registration, Graduate Director will have an authority to override.
- Graduate Director would like to view a report showing a student’s class registration history by semester and year and the total credit remaining for his/her successful graduation. PLEASE PROVIDE A SQL query to generate the REGISTRATION REPORT.
- Please recommend any other reports that your E-R diagram design can generate which may be beneficial for the Graduate Director’s analysis purposes.
Related Book For
Statistics for Managers Using Microsoft Excel
ISBN: 978-0133130805
7th edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat
Posted Date: