Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Objective: Develop Pseudocode In this exercise you will write up pseudocode (refer to Pseudocode Standard Links to an external site, [t]) to show how to

image text in transcribed

Objective: Develop Pseudocode In this exercise you will write up pseudocode (refer to Pseudocode Standard Links to an external site, [t]) to show how to implement is Student Roster Infomation System (Java and C++ programs, Oracle (C\# and Java programs, MS SQL Course Registration Information System architecture) Figure 1: Lion University Course/Roster System Refer to the schema figures provided below: Figure Ex1.1 shows the schema used in the Lion University's Student Roster Information System (simply called Roster System). Figure Ex1:2 shows the schema used in the Lion University's Course Registration Information System (simply called Course System). (simply called Course System). Figure Ex1.1 Schema of the Lion University's Student Roster Information System Figure Ex1.2 Schema of the Lion University's Course Registration Information System Assume that Roster System has a record for a new student, Bob Smith, in Table StudentRoster - StudiD (Integer): 1111 - Name (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: 1. your assumption of an appropriate communication between the Roster and the Course systems 2. your preferred programming model (i.e., one out of five: RPC, Object-oriented, Interface-based, Component-based, or Service-oriented 3. your integration diagram that shows the scheme and logic of your proposed integration (e.g., UML or the like) 4. your pseudo codes, i.e., module(s) for the Roster system, module(s) for the Course system, and module(s) for their integration respectively 5. discussion on what are the potential challenges when doing such an implementation for real

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

8th Edition

013460153X, 978-0134601533

More Books

Students also viewed these Databases questions

Question

What information remains to be obtained?

Answered: 1 week ago

Question

13-6 How will MIS help my career?

Answered: 1 week ago