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
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.