CN4000 Information Systems Modelling and Design Assignment one Coursework: Group Assignment 2025/26 | UEL

Assignment Details

CN4000 Group Coursework– 80%

Please read the whole assignment to ensure you understand all the requirements before you begin.

This assessment should be attempted in groups of 4 students.

You must keep regular minutes of any meetings that you have while undertaking this course work as they will be required if there is a dispute about any members' contribution. Your minutes should:

• be dated
• include a list of all group members present and apologies for any absences
• include allocation of work to be achieved by each member by the next meeting
• include the time, date and venue of the next meeting
• be signed to indicate the agreement of all group members, present or not.

All individuals will receive the group grade for this coursework unless clear evidence is provided of unequal contributions.

The marking criterion for the Coursework is based on the assessment criteria at the end.

Deliverables Assignment Report of no more than 2500 words (80 %)

Coursework Brief: Smart Travel and Holiday Booking Agency Deliverables

Scenario: GlobeTrek Smart Travel Agency

You have been appointed as a Technology Consultant for GlobeTrek Travel Agency, a rapidly growing company that specialises in personalised travel experiences.

GlobeTrek operates both online and through physical branches across the UK and Europe. It offers customers a full range of travel services including flight bookings, hotel reservations, local tours and experiences, and travel insurance packages.

The company’s current systems are outdated, with several manual processes still in use for booking management, customer communication, and payment tracking. Management is therefore seeking to develop an integrated smart travel management system that improves efficiency, enhances the customer experience, and ensures data security across all platforms.

Your role is to analyse the existing systems, recommend improvements, and design a new integrated information system suitable for GlobeTrek’s operational needs.

Task 1: Understanding the Organisation and Its Information Systems

Task 1.a (5 Marks)

Briefly introduce GlobeTrek Travel Agency — its structure, operations, and services. Identify the types of Information Systems (IS) and IT specialists that the organisation currently uses or would likely need to support its operations — both in-house (e.g., IT administrators, data analysts, system developers) and outsourced (e.g., web hosting, cloud services, payment gateway providers).

Select one of the systems currently in use — for example, Online Booking System, Customer Relationship Management (CRM), or Inventory and Supplier System.

Describe the system in detail, identifying its hardware, software, data, and people resources.

Task 1.b (5 Marks)

Select one of the systems identified in Task 1.a (e.g., the Online Booking and Payment Platform).

Perform a system analysis and suggest improvements that could make the system more efficient and effective in achieving business goals such as faster bookings, secure payments, or improved customer satisfaction.

Task 2: System Development and Design Methodologies (10 Marks)

Based on your findings, propose a new system to replace or enhance the existing one, for example, a Smart Integrated Travel Management System (SITMS) that connects flights, hotels, and activities on one platform.

Explain the System Development Life Cycle (SDLC) and the information system modelling/design methodology (e.g., Agile, Scrum, or Waterfall) you would apply in developing the system.

Justify your choice of methodology based on GlobeTrek’s needs, team structure, and customer interaction requirements.

Task 3: Data Security, Ethics, and Legal Compliance (5 Marks)

GlobeTrek manages large volumes of customer data including personal details, passport information, and payment records.

Discuss the data security measures that should be implemented to safeguard this sensitive information (e.g., encryption, firewalls, access control, data backups).

Explain the social, ethical, and legal issues involved in managing such data, and how the organisation must comply with UK GDPR and Data Protection Act 2018 to ensure data privacy and customer trust.

Task 4: Project Planning and Team Collaboration (5 Marks)

Demonstrate how you would plan and manage the system development project.

• Task 4.a – MS Project: Explain how MS Project can be used to track and monitor the project timeline, resources, and dependencies.
• Task 4.b – Work Breakdown Structure (WBS) and Gantt Chart: Create or outline these tools to show how the project tasks are structured and scheduled.
• Task 4.c – Minutes of Meetings: Describe the purpose of meeting minutes in maintaining accountability and progress tracking.
• Task 4.d – Task Allocation: Create a table showing how project tasks would be distributed among team members.
• Task 4.e – Task Evaluation: Reflect briefly on how each group member evaluated their own contribution and teamwork.

Task 5: System Modelling and Design

Your proposed system should meet GlobeTrek’s operational needs.

The company may have multiple branches across different countries, each with managers, customer service agents, and travel consultants who assist clients both in person and online. The system must handle flight bookings, hotel reservations, tours and activities, payments, cancellations, and customer feedback. It should also cater to special customer types such as VIP clients and corporate travellers.

Task 5.a – Entity Relationship Diagram (ERD) (10 Marks)

Identify and illustrate the entities required for the proposed system (e.g., Customer, Flight, Hotel, Tour, Payment, Branch).
Show the relationships between entities using an ERD (you may use Draw.io, Lucidchart, or MS Access).
Include any assumptions you make.

Task 5.b – Schema and Attributes (5 Marks)

List all attributes for each entity and present them in a schema table. Clearly identify:

• Primary Keys (PK) and Foreign Keys (FK)
• Data Types (e.g., INT, VARCHAR, DATE)
• Null/Not Null constraints

Task 5.c – Use Cases and Data Flow Diagrams (10 Marks)

Conduct a requirements analysis to define how users interact with the system. Create Use Case Diagrams and case descriptions for processes such as:

• Booking a flight or hotel
• Cancelling or modifying reservations
• Making payments
• Viewing invoices or itineraries

Also include a Level 0 DFD, and optionally a Level 1 DFD for a specific process (e.g., Process Booking or Manage Payments).
Consider security and access privileges, for example:

• Customers can view bookings and download itineraries.
• Staff can update bookings and process payments.
• Managers can authorise refunds and access reports.

Task 5.d – Academic Integrity and Presentation (5 Marks)

Your work must demonstrate academic writing standards, appropriate Harvard Referencing, and clear evidence of academic integrity (e.g., Turnitin originality report).

Task 6. Presentation and Presentation slides (20 Marks)

Please include your presentation slides into the report.

Assessment Criteria: