Superior Essay Writers | UNIT CODE: 6G4Z1003 UNIT DESC: INFORMATION SYSTEMS ASSESSMENT ID: 1CWK65

UNIT CODE: 6G4Z1003 UNIT DESC: INFORMATION SYSTEMS ASSESSMENT ID: 1CWK65

Project description
This assignment requires that you carry out an analysis of Travel and Tourism Ltd existing system (case study attached) and from this analysis produce a set of

recommendations for its improvement and implementation. The analysis and recommendations are to be presented in the form of a System Analysis and Design Report – the

contents of the report is to be:
? Presentation of report: report should be well structured and written. (5 marks)
? Introduction: explaining the purpose of the report and its contents. (5 marks)
? Problems and Requirements: a description of the problems with the current system and recommendations for how the system can be improved. (10 marks)
? Management Information Proposal: this will consist of a list of reports you would recommend (each with a brief explanation). (10 marks)
? Use Case Diagram with Use Case Specifications of the proposed system and prioritisation of core functionality. (15 marks)
? Entity Relationship Diagram (ERD) of the proposed system (using UML diagramming conventions) with a data dictionary. (20 marks)
? Relational Data Analysis (RDA) of the ASF (in tabular form showing UNF, 1NF, 2NF and TNF). Plus a comparison with the ERD previously generated. (15 marks)
? Specifiy CREATE and DROP statement syntax for ORACLE to cover the core functionality specified in your ERD (you do not have to run it in ORACLE but it might help you

if you do). (20 Marks)
In this assignment you will be assessed on your ability to model and analyse a system using standard systems analysis techniques. You will also be assessed on your

ability to present the results of your analysis in a clear and concise manner. This will include the correct and consistent application of the techniques, an accurate

representation of the described system and a professional presentation of your report. For all parts of the assignment, clarity is important – so use brief but well

written explanatory notes, as required, to make the description of the system more easily understood. Any assumptions and observations you make regarding the system

must be clearly explained.

Case Study: Travel and Tourism Ltd
Travel and Tourism Ltd (TaT) advertise and manage properties for rent in popular
holiday resorts around the Eastern Mediterranean and Black Sea coasts. Properties
can be registered with TaT by their owners or by an agent who acts on behalf of one
or more owners.
When property owners, or agents, register their property with TaT they must provide
information about their property. TaT staff will use this information to complete an
Accommodation Specification Form (ASF). An example ASF is shown in the figure
below. Historically TaT only used to deal with agents so the ASF was used to store
agent details and then list all details of properties from that agent. More recently TaT
has begun to operate directly with owners and so in these cases the owner is also
considered to be the agent (they are assigned an Agent ID) and only one property is
entered on the ASF.
For all properties, a copy is made of the owner’s details which are saved in the
Owner File, whilst the completed ASF is filed by agent name in the property file.
Agent’s details are currently not stored separately from the property details.
Customers will contact the TaT Enquiries Desk with general enquiries regarding
accommodation and availability. It is company policy that an enquiry will always result
in some form of communication back to the customer. However, due to the
persuasive skills of the Enquiries Desk team, general enquiries often also result in a
booking.
Bookings (either directly from a customer or through the Enquiries Desk) will always
be handled by the Booking Department. Property details and rates are checked
against the booking request provided by the customer, as is the availability of the
property. If everything is in order then a booking is recorded, the deposit taken and
the availability of property details will be adjusted accordingly. The customer will
receive a confirmation of the booking.
If there are any problems with the booking then alternative accommodation may be
offered but on the rare occasion that a booking cannot be made the customer is sent
a cancellation notice and their deposit refunded.
All payments to TaT must be taken through the Accounts Section. Deposits sent with
bookings will be directed there (a deposit will be payment number one for a particular
booking), and customers who are making advance payments for their
accommodation will send payments directly to the Accounts Section. Receipts will be
issued for every payment received.
The Accounts Section also handles payments of rental fees to owners and agents.
At the end of each month, the Accounts Section will calculate the rental income
generated by one or several properties, subtract its commission (usually 2.5%), and
send the remainder to the owner. In the cases where an agent has provided the
property details, payment is sent to the agent rather than the owner. This allows the
agent to subtract their own fees before sending the remainder to the owner.
Continued…

FACULTY OF SCIENCE AND ENGINEERING
This assignment requires that you carry out an analysis of Travel and Tourism Ltd existing system

case study attached) and from this analysis produce a set of recommendations for its improvement and implementation
.
The analysis and recommendations are to be presented in the form of a System Analysis and Design Report–the contents of the report is to be:
?
Presentation of report: report should be well structured and written. (5 marks)

Introduction: explaining the purpose of the report and its contents.

Problems and Requirements: a descript
ion of the problems with the current system
and recommendations for how the system can be improved.

Management Information Proposal

: this will consist of
a list of reports

you would recommend (each with a brief explanation).

Use Case Diagram with Use Case Specifications of the proposed system and prioritisation of core functionality

Entity Relationship Diagram (ERD) of the proposed system (using UML diagramming conventions)
with a data dictionary.

?
Relational Data Analysis (RDA) of the ASF (in tabular form showing UNF, 1NF, 2NF and TNF)

.
Plus a comparison with the ERD previously generated.

Specifiy CREATE and DROP statement syntax for ORACLE to cover the core
functionality specified in your ERD (you do not have to run it in ORACLE but it might
help you if you do).

In this assignment you will be assessed on your ability to model and analyse a system using
standard systems analysis techniques. You will also be assessed on your ability to present
the results of your analysis in a clear and concise manner. This will include the correct and
consistent application of the techniques an accurate representation of the described system
and a professional presentation of your report . For all parts of the assignment, clarity is
important so use brief but well written explanatory notes, as required, to make the
description
of the system more easily understood. Any assumptions and observations you
make regarding the system must be clearly explained.

Continued…
Case Study:
Travel and Tourism Ltd
Travel and Tourism Ltd (TaT) advertise and manage properties fo
r rent in popular
holiday resorts around the Eastern Mediterranean and Black Sea coasts. Properties
can be registered with TaT by their owners or by an agent who acts on behalf of one
or more owners.
When property owners, or agents, register their property
with TaT they must provide
information about their property. TaT staff will use this information to complete an
Accommodation Specification Form (ASF). An example ASF is shown
in the figure
below
. Historically TaT only used to deal with agents so the ASF
was used to store
agent details and then list all details of properties from that agent. More recently TaT
has begun to operate directly with owners and so in these cases the owner is also
considered to be the agent (they are assigned an Agent ID) and onl
y one property is
entered on the ASF.
For all properties, a copy is made of the owner’s details which are saved in the
Owner File, whilst the completed ASF is filed by agent name in the property file.
Agent’s details are currently not stored separately fr
om the property details.
Customers will contact the TaT Enquiries Desk with general enquiries regarding
accommodation and availability. It is company policy that an enquiry will always result
in some form of communication back to the customer. However, due
to the
persuasive skills of the Enquiries Desk team, general enquiries often also result in a
booking.
Bookings (either directly from a customer or through the Enquiries Desk) will always
be handled by the Booking Department. Property details and rates a
re checked
against the booking request provided by the customer, as is the availability of the
property. If everything is in order then a booking is recorded, the deposit taken and
the availability of property details will be adjusted accordingly. The cus
tomer will
receive a confirmation of the booking.
If there are any problems with the booking then alternati
ve accommodation may be
offered
but on the rare
occasion
that a booking cannot be made the customer is sent
a cancellation notice and their deposit r
efunded.
All payments to TaT must be taken through the Accounts Section. Deposits sent with
bookings will be directed there
(a deposit will be payment number one for a particular
booking)
, and customers who are making advance payments for their
accommodati
on will send payments directly to the Accounts Section. Receipts
will be
issued for every payment received.
The Accounts Section also handles payments of rental fees to owners and agents.
At the end of each month, the Accounts Section will calculate
the r
ental income
generated by one or several
propert
ies
, subtract its commission (usually 2.5%), and
send the remainder to the owner. In the cases where an agent has provided the
property details, payment is sent to the agent rather than the owner. This allow
s the
agent to subtract their own fees before sending the remainder to the owner.
Continued…