COMP3760/6760 Enterprise Systems Integration

Department of Computing
Semester 2, 2020
COMP3760/6760: Enterprise Systems Integration
Assignment 3 (Group Assignment): System Integration
(20% of the semester)
Prof Jian Yang
Due 11:55 pm Tuesday – 20 October 2020
COMP3760/6760 Assignment 3 Semester 2, 2020
Page 2
Business Process Modelling for improved Project Management Processes
(source: Busch, P., Amirmazaheri, A., (2012) “Workflow Knowledge Sharing through Social Networks”
Pacific-Asia Knowledge Acquisition Workshop (PKAW 2012)/Lecture Notes in Artificial
Intelligence (LNAI 7457) Kuching, Malaysia, September 5-6th pp: 343–349.
Background: LCPL, A SYDNEY-BASED COMPANY
LCPL is an actual mining and construction enterprise headquartered in Sydney with more than 5000 employees
across Australia. LCPL undertakes projects within the Asia-Pacific region, mainly in Australia and New
Zealand. The company delivers projects for clients across the infrastructure, resources, civil engineering, energy
and telecommunications sectors.
The Process: Oracle Primavera P6
The Control and Planning group of LCPL provides systems and processes to manage and control projects.
Oracle Primavera P6 is a project management tool managed by Group Operational Services (GOS) of the
Control and Planning (CP) division of LCPL. Group Operational Services supports other business units
through developing and maintaining control and planning standards and methodologies.
All divisions within LCPL should use P6 for their project planning, update and control purposes. The GOS
supports all Oracle Primavera P6 users across the company through a defined process (figure 1). To support P6
users, the GOS cooperates with LCPL’s IT group to integrate the support process with the IT service deskfor
the company. The IT service desk uses IT Service Management (ITSM) help-desk software as a support tool to
log requests, changes and incidents. The P6 support process is illustrated here for brevity (figure 1).
Figure 1: The GSO support process (source: LCPL intranet).
Project Brief (4 marks)
Provide a description on: the group meeting schedule or plan, each member’s role in the project, identifying risks
and ways to manage risks, ways to communicate between members, and a log recording each meeting,
discussion and dialogue between members in relation to the project. Note: all members need to contribute to the
project. The description and log need to be submitted together with the four tasks.
Task 1 Web Service Design (4 marks)
Suppose you are wrapping the GSO support process (figure 1) as a web service, which allows a user to create a
request for an incident raised. You are required to:
• Identify the two necessary functions of this GSO service;
• For each of the above functions, identify the input/output messages;
• Use WSDL interface definition constructs to specify the above identified functions with input/output
messages.
Task 2 XML Schema Design (4 marks)
For the above input/output messages, write their XML Schemas. You need to include the following:
• Two different ways of specifying complex types, one is defined inside the element, the other defines a
complex type first, then (re-)uses it as a complex type of an element;
• Use constraints on the values of a simple typed element, on the occurrence of elements;
• Pick up one xml schema, construct a sample xml document.
Task 3 EAI and Database Integration (4 marks)
Suppose LCPL’s head office in Sydney maintains a personnel database containing information such as Senior
Planners, Optimisation Manager, Planners, Site Engineer, Planning Manager, Scheduler, Systems Analyst and
Business Analyst along with their detailed information. Other sites have their own databases containing
information on projects undertaken, issues and incidents reported, changes made and staff in charge of issues to
be resolved etc. In order to support the need of business analysis, LCPL sees a need to integrate systems running
across Australia and New Zealand. The objective of business analysis is to allow managers to make better
decisions on the project chosen, supply management and human resource management.
For example, suppose an applicant wishes to check the frequencies of various issues reported in the system and
the information on staff assigned to those issues. This request would actually require data from multiple
disparate back-end systems and different sites. In this case, there is a need to decompose the request into
multiple requests to be sent to the different back-end database applications, gather the information sent back, and
assemble this information in the form of a single uniformed response (i.e. recompose).
• Design simple database schemas for the above scenario and explain what kind of integration technique
you would use. Assume the back-end databases are relational.
• Design and draw a tiered EAI system handling this situation whereby users gain direct access to business
applications and data.
• Explain how queries will be decomposed and replies recomposed. You may make the necessary
assumptions.
Task 4 Discussion (4 marks, @ 600 words)
“LCPL is an actual mining and construction enterprise headquartered in Sydney with more than 5000
employees across Australia. LCPL undertakes projects within the Asia-Pacific region, mainly in Australia and
New Zealand. The company delivers projects for clients across the infrastructure, resources, civil engineering,
energy and telecommunications sectors”, from this description we can image there are different systems
implemented in different sites of LCPL. Use what you have learned in the unit to discuss the following:
• The possible issues relating to integration (from different layers/aspects) using examples;
• The possible technologies potentially used to support system integration at various levels/aspects;
• The options and considerations of the technologies along with their advantages and disadvantages
Submission: one submission per group, together with the project description and log.
Zero Tolerance for Cheating:
You are required to use your own words to provide the descriptions and explanations. All submissions will be
checked for plagiarism. Any cases will be reported to the faculty for disciplinary action, and the marks of the
assignment and the unit will be withheld until the case has been resolved. See Macquarie University’s code of
conduct for the details of the process: https://students.mq.edu.au/study/getting-started/student-conduct.
Submission
Place your soft copy in your assignment 3 submission folder on iLearn.
Due 11:55 pm Tuesday – 20 October 2020 (Hard deadline)
Marking Rubric

Developing
(Borderline Pass-Fail)
Functional
(Pass)
Proficient
(Credit)
Advanced
(Distinction-High
Distinction)
System
Integration
Showing some
understanding of
system integration
Showing
understanding of
system integration, can
apply technologies in
the business case
Good understanding of
system integration
issues, can explain and
use the technologies
proficiently and
appropriately without
any significant
mistakes
Excellent
understanding of
system integration and
can explain and use
the technologies at an
expert level
XML, web
service
Limited
understanding of
XML, web services,
some obvious
mistakes
Competent
understanding of XML
and web services,
some trivial mistakes
still in evidence, but
generally an
understanding of what
is taking place
and why
Some incorporation of
the literature beyond
just competent
understanding of
XML and web
services
An excellent grasp of
XML and web services,
also drawing on the
literature widely to
exemplify in the case of
further examples how
XML and web services
has aided system
integration as well
HelpHub
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose HelpHub

HelpHub

Quality Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

HelpHub

Qualified Writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

StudyAcer

Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account.

StudyAcer

On Time Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. We will always strive to deliver on time.

StudyAcer

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.

StudyAcer

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Help Hub

Place your order

Fill in the order form and provide all details of your assignment.

Help Hub

Proceed with the payment

Choose the payment system that suits you most.

Help Hub

Receive the final file

Once your paper is ready, we will email it to you.

HelpHub Writing Services

No need to work on essay at night. Sleep tight, we will cover your back. We offer all kinds of essay writing services.

HelpHub HelpHub

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

HelpHub HelpHub

Admissions

Admission Essays

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

HelpHub HelpHub

Editing

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

HelpHub HelpHub

Revision

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied.