question archive WSU is experiencing a high number of student intakes and the immediate concern is the lack of adequate transportation facilities from major stations such as Parramatta
Subject:Computer SciencePrice: Bought3
WSU is experiencing a high number of student intakes and the immediate concern is the lack of
adequate transportation facilities from major stations such as Parramatta. Further to this is the
added complication of non-availability of free parking. The university has come up with solutions
such as a dedicated bus route from University to Major bus interchange/station, monorail link to
Rydalmere station. The university is also looking to integrate the Opal ticketing system with their
student database to track the number of students using public transport or the mono rail and offer
travel concession to students on their travel costs when using the OPAL card wherein a tap on tap
off at the University bus stop or monorail is recorded in the system and every student gets a travel
concession up to 40 dollars per month. The following is the process flow/description for the WSU
transport management information system. Firstly the OPAL ticketing system is integrated with the
University student database and they form an information system of student details, OPAL card
details, Record the number of trips made by students to and from the university. The database is a
Oracle based data base system supported by 2 high capacity servers of the university. When a
student taps on or off at the university bus stop or the train station, the trip details is recorded in
the information system and the OPAL card number is searched and matched with a student record
in the database. Subject to student records being matched, the university IT admin staff generates
a monthly report on the student information software which contains the total number of trips
made by students and their relevant costs. This report is later sent to the data analytics team to
segregate the number of students who have spent more than 40 dollars a week on transport to the
university and process the concession for the students onto the accounting system. The accounting
software then credits back the amount into the student's bank account on a monthly basis. WSU is
keen to implement the information system in a phased manner as there is considerable amount of
system upgrades to be done. WSU still has challenges to iron out especially in the System
integration with the OPAL and linking of the data base. The current priority of WSU is to ensure
that the current system are capable of the new data needed to be entered and reporting details to
be passed onto the other departments. Cost is also a factor with funding only being given on a half
yearly basis and additional expenses have to go through several layers of approval. It is a wellknown
fact that in order for the Information system to be fully operational, every component
(hardware and software) need to be upgraded, developed and integrated.
Q. Recommend the SDLC methodology you would use in developing the Transport
Management Information System for WSU and explain why you have recommended it.