Write up pseudo codes show how to implement a remo te computing service Student Roster Information System (Java program, Oracle Database, traditional client/server archite cture) Course Registration Information Svstem (C# program, MS SQL database, web-based/.Net architecture) Figure 1: University Course/Roster Svstem Figure Ex1.1 shows the schema used in the University's Student Roster Information System (simply called Roster System). Figure Ex1.2 shows the schema used in the University's Course Registration Information System (simply called Course System) StudentRoster Progranm StulD Name SSN EmailAddress HomePhone LocalAdd HomeAdd EmergencyContact ProgramID PaymentID AcademicStatusID Fee ProgramID Name FeelD SpecialRate College AcademicStatus StudentCourseInProgress AcademicStatusID StatusType Remark Credt FeeID Payment PaymentID Status Figure Ex1.1 Schema of the Universitv's Student Roster Information Svstem Student Faculty StudenkID FacutyID FacutyName Office Phone Email Course CourselD CourseSchedulelD CourselD Semester Schedule Time Location Capacity FacultyID StudentCourse Student CourselD CourseSchedulelD Paid Grade Availability Student Faculty StudentID FacukyI FacuktyName Office Phone Email Course CourseSchedule CourseID CourseSchedulelD CoursetD Senester Schedule Time Location Capacity FacultyID StudentCourse Prerequisite CourseSchedulelD Paid Grade Availability Figure Ex1.2 Schema of the Universitv's Course Registration Information Svstem Assume that Roster System has a record for a new student, Bob Smith, in Table StudentRoster StudID (Integer): 1111 Nae (String): Bob Smith SSN String): 222-333-1111 EmailAddress(String): bsmith@yahoo.com HomePhone(String): 215-777-8888 HomeAddr(String): 123 Tulip Road. Ambler, PA 19002 LocalAddr(String): 321 Maple Avenue. Lion Town. PA 16800 . EmergencyContact(String): John Smith (215-222-6666) . ProgramID(Integer): 206 PaymentID(String): 1111-206 AcademicStatus (Integer): 1 Design/develop pseudo codes to insert the needed Bob Smith information from the Roster System into the Course System. Your report should include at least the following: your assumption of an appropriate communication between the Roster and the Course svstems 1. 2. your preferred programming model (i.e., one out of five: RPC, Object-oriented, Interface- 3. 4. discussion on what are the potential challenges when doing such an implementation for based, Component-based, or Service-oriented) your pseudo codes, i.e., module(s) for the Roster system, module(s) for the Course system, and module(s) for their integration if needed real Write up pseudo codes show how to implement a remo te computing service Student Roster Information System (Java program, Oracle Database, traditional client/server archite cture) Course Registration Information Svstem (C# program, MS SQL database, web-based/.Net architecture) Figure 1: University Course/Roster Svstem Figure Ex1.1 shows the schema used in the University's Student Roster Information System (simply called Roster System). Figure Ex1.2 shows the schema used in the University's Course Registration Information System (simply called Course System) StudentRoster Progranm StulD Name SSN EmailAddress HomePhone LocalAdd HomeAdd EmergencyContact ProgramID PaymentID AcademicStatusID Fee ProgramID Name FeelD SpecialRate College AcademicStatus StudentCourseInProgress AcademicStatusID StatusType Remark Credt FeeID Payment PaymentID Status Figure Ex1.1 Schema of the Universitv's Student Roster Information Svstem Student Faculty StudenkID FacutyID FacutyName Office Phone Email Course CourselD CourseSchedulelD CourselD Semester Schedule Time Location Capacity FacultyID StudentCourse Student CourselD CourseSchedulelD Paid Grade Availability Student Faculty StudentID FacukyI FacuktyName Office Phone Email Course CourseSchedule CourseID CourseSchedulelD CoursetD Senester Schedule Time Location Capacity FacultyID StudentCourse Prerequisite CourseSchedulelD Paid Grade Availability Figure Ex1.2 Schema of the Universitv's Course Registration Information Svstem Assume that Roster System has a record for a new student, Bob Smith, in Table StudentRoster StudID (Integer): 1111 Nae (String): Bob Smith SSN String): 222-333-1111 EmailAddress(String): bsmith@yahoo.com HomePhone(String): 215-777-8888 HomeAddr(String): 123 Tulip Road. Ambler, PA 19002 LocalAddr(String): 321 Maple Avenue. Lion Town. PA 16800 . EmergencyContact(String): John Smith (215-222-6666) . ProgramID(Integer): 206 PaymentID(String): 1111-206 AcademicStatus (Integer): 1 Design/develop pseudo codes to insert the needed Bob Smith information from the Roster System into the Course System. Your report should include at least the following: your assumption of an appropriate communication between the Roster and the Course svstems 1. 2. your preferred programming model (i.e., one out of five: RPC, Object-oriented, Interface- 3. 4. discussion on what are the potential challenges when doing such an implementation for based, Component-based, or Service-oriented) your pseudo codes, i.e., module(s) for the Roster system, module(s) for the Course system, and module(s) for their integration if needed real