I just need the current graduate student part done in python, Business requirement and ERD provided
Business Requirements Applicant Applicant Creation An applicant must be able to access a “website” to see all available actions that can be taken An applicant must provide personal information in the form (see section 9 for info details) Application Application Creation An applicant must provide academic information in the form (see section 10 for info details) An applicant must provide application specific information in the form (see section 11 for info details) Application Submission After an applicant submits their application, the “website” provides the applicant a student number After submission, the application is evaluated by the system (see section 2cii for application statuses) Application Status Below flow diagram describes the application status IF App is missing data THEN Application Incomplete ELSE “Application Complete and Under Review / No Decision Yet” Status’ include: Admit Admit with Aid Reject Application Queries An applicant can query the status of their application from the “website” using their student number Update personal or academic information Graduate Secretary GS Queries A Graduate Secretary may update [MODIFY] the application status Search for an applicant using their last name or Student Number Update an applicants’ personal or academic information Given a Semester or Year or Degree Program, generate the list of graduate applicants Given the Semester or Year or Degree Program, generate the list of admitted students Given the Semester or Year or Degree Program, generate total # of applicants, total # admitted, total # rejected, and avg GRE score for admitted students Given the Semester or Year or Degree Program generate a list of students cleared for graduation Given the Semester or Year or Degree Program generate a list of alumni and their email addresses Generate total list of current students (by degree or by admit year) Change Student’s Faculty Advisor, given a student number. Generate the list of courses and grades, given a student number. Generate list of all advisees, given a faculty advisor name Alumni Alumni Queries Request their transcript Update their personal information using their student ID to authenticate (see section 9) Current Graduate Student Student Enrollment A Student is enrolled once application has been completed and application decision is admitted or admitted with aid. See section 2d on application statuses. Student Course Registration A Student may enroll in a course. See section 12 on course information. Student Graduation Application A student may visit the “website” and apply for graduation System “audits” if student has satisfied program requirements (see section 14 on graduation requirements) If the student is not cleared for graduation they are informed what requirements they are missing Queries Generate the list of courses and grades, given a student number. View course list View grades Faculty Advisor Queries Generate the list of courses and grades, given a student number. View all data about an applicant but cannot enter a review View their advisees’ courses taken but cannot update the courses. Generate a list of all advisees Faculty Instructor Queries Generate the list of courses and grades, given a student number. Enter grades for the students in the courses they are teaching (i.e., courses for which they are the instructor). See section 12 on grades. Faculty Reviewers Queries Search for an applicant using their last name or Student Number Generate the list of courses and grades, given a student number. Review a student’s application Enter their review into a review form which is stored in the system. Personal Information All personal information must be protected from users who do not have access. For read/write allowances, see section 9c The following information must be provided by all applicants Name Address Street Number City State Zip Phone Numbers Work Mobile Home Email address Read/Write Allowances for Personal Information Read Only Faculty Advisor Graduate Secretary Read/Write Student Alumni Applicant Graduate Secretary Academic Information Prior Degrees (max 2) Degree years GPA per degree Univ/College of each degree GRE Score Verbal Analytical Quantitative Other Application Information Program Sought [MS or MSE] Applicant Date Received (MM/DD/YYY) Admission Date Request (W2023, S2022, or F2022) (optional) Area of Interest Prior Work Experience (1 or 2 sentences) Recommendation Letters (max 3) Authors Name Email address Title Affiliation Database University Students must be able to enroll and register for courses through the DBU. See section 12c on course registration. Course Information Title Course number Section number Semester Number of course credits Course Registration Information Course – see section 12b on course information Course section number Semester Student identification Instructor information Grade Grade can be either A,B,C or F Graduation Application Students must fulfill below requirements in order to graduate Has taken 10 courses (3 credits each) totalling to 30 credits hours Has taken 3 out of the 4 core courses: CS510, CS511, IMSE5212, IMSE 513 Has at most 2 grades below B Has a minimum GPA of 3.0 Graduation statuses are limited to: Cleared Not Cleared Process Workflow Application Process An Applicant fills out personal and academic information. An Applicant is notified if any required fields are missing. An Applicant submits an application once all required fields are filled. An Applicant may check on the status of their application. A date the application was received by the department is recorded. Admission Process The GS scores the application. The faculty reviews the application. The Chair of the admissions with the help of the GS admits, admits with aid, or rejects an applicant. The admission or rejection date is recorded. Registration and General Student Process A Student accepts the admission decision and the GS adds the Student in the system. A Student who has been enrolled in the University registers for a class. A Faculty member who instructs a class may update a student’s grade A Student or Faculty member may check on their grades. Graduation Process Student apply for graduation by filling out an online form with list of courses they will take to meet graduation requirements System automatically check if graduation requirements are met If requirements are met, student graduation application status changed to ‘cleared’. Otherwise, status is ‘‘not cleared’ GS generates the list of graduating students (students whose graduation application status is ‘cleared’). GS only checks the “cleared” students and approves their graduation by checking their folder and transcript. If student graduation application status is ‘cleared’, GS then removes the student from the ‘graduate student’ list and adds them to alumni list. Enrollment information must not be removed Alumni are then able to edit their personal information using their student number to authenticate. Alumni are able to view a list of the courses they took and their grades