Create a normalised data structure


Problem: The overall objective of assignments 1 and 2 combined is that the students should acquire an overview of principles, methods and techniques of systems development, and gather experience from a development project in which a specific development method is used. On successful completion of this assignment students should be able to:

A) Define and explain the fundamental concepts methods and techniques used in information systems analysis and design.

B) Apply contemporary information systems analysis and design methods and techniques to a realistic case study.

C) Effectively communicate systems analysis and design methods and techniques to real world problems.

Introduction and Background:

Early in 2010, Mr Pavlov and Mrs Norris established a boarding kennel for cats and dogs (hereafter referred to as Pampered Pets Palace or PPP) in the Western suburbs of Brisbane. The kennel operates 7 days a week. The kennel capacity is as follows: 50 cat runs, 100 single-dog dog runs and 25 two-dog dog runs. The kennel has also recently completed 30 luxury units (20 for dogs and 10 for cats). In addition to simply providing board for animals, PPP, also provides additional services such as grooming, flea treatments etc. The kennel employs a number of staff in a variety of operations. Both owners are also actively involved in the day to day operations. There is a fulltime receptionist/office worker, Phyllis, and a number of kennel hands.

Now you have interviewed the Pampered Pets team, and you and have established their requirements for the TO-BE system to address the problems of no-show bookings, unavailability of pet accommodation and services not being provided. You may also provide the Pampered Pets team with some additional reports.

The sections below as the same as you will find on StudyDesk, and they are the deliverables you will be marked on. Please pay particular attention to the Assignment Details, Instructions, and Rubric available via the CIS5200 StudyDesk

Pampered Pets Palace-Time Management plan

Develop a Work Breakdown Structure (WBS) for the entire project through to delivery and, as you did in assignment 1 identify all the tasks to be undertaken, who will do them, and their start and finish times. This time your WBS will reflect a typical system development lifecycle including tasks around planning analysis design and implementation.

TO-BE Process:

Develop a "TO BE" process diagram by using Business Process Modelling Notation (BPMN) or Unified Modelling Language (UML). The "TO BE" diagram should show the improvement of the process flow the organisation. Take into account:

  • Customer information (owner and pet)
  • Bookings made
  • Payments
  • Any other data entry/input processes you consider necessary.
  • Reporting, including

o Invoices

o Sales Summaries

o Any other reports you consider necessary that could be valuable to the owners

Comparing "AS IS" and "TO BE" Process

You need to make a professional comparison between the "AS IS" process diagram that you provided in the assignment 1, and "TO BE" process diagram to assess the impact of change and prepare a briefing note for Mrs Norris,who has taken on the role of change manager, regarding the anticipated impact of the system. You should make recommendations to the management of PPP on how these impacts can be managed.

Entity Relationship Diagram (ERD)

Draw and ERD for PPP showing all the entities and their attributes, identifying keys, and relationships including cardinality as described in Module 9 and its associated readings

Data Normalisation

Using all the entities identified in your ERD, create a normalised data structure (to 3rd Normal form as described in Module 9 and its associated readings) for PPP that will ultimately form a relational database to store the company data.

Testing

What types of testing should be performed? What types of test data should be used? The testing in relation to the new Information Systems developed to automate the organization process? Please clarify this.

Training

Identify the specific groups of people who need training on the new system. For each group, describe the type of training you would recommend and list the topics you would cover.

System Changeover

Develop a plan for system changeover for the organisation. Discuss the method that should be used for systems changeover to enable "TO BE" process in the organisation.

Report to Top Management

Assume you have completed the design and implementation phases of your project for the organisation. Write a report to the top management (CEO). This report at a minimum should include the objectives, processes undertaken, scope, and recommendations to the top management (CEO).

Presentation/Report Structure

This task includes providing a cover page (title page) for your report and writing up your report details with clarity and professionalism.

The main aim of our Information Systems Analysis and Design Assignment Help service is to assist all the students, who are not able to write their own assignment paper without any trouble.

Tags: Information Systems Analysis and Design Assignment Help, Information Systems Analysis and Design Homework Help, Information Systems Analysis and Design Coursework, Information Systems Analysis and Design Solved Assignments, Time Management Plan Assignment Help, Time Management Plan Homework Help, Entity Relationship Diagram Assignment Help, Entity Relationship Diagram Homework Help

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: Create a normalised data structure
Reference No:- TGS03032820

Expected delivery within 24 Hours