FACULTY OF HIGHER EDUCATION
Individual Assignment
HS2011 Systems Analysis and Design
Trimester 2 2015
Date Due: Friday Week 10, 2015 by 5:00 PM)
Marks: Weighting 15%
Student Name (Block letters) Student Number:
___________________________ _____________
| HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION |
HS2011 Systems Analysis and Design – Trimester 2 2015 1
Using below the Sally’s Pet Store Case Study, you are to prepare User
Requirements Document. It is suggested that a framework for the document could
be based on the following structure:
1. Business Overview (Goals, Business Objectives, Current Business Situation,
Problems, Gaps, Opportunities)
[4 marks]
2. Data Gathering( such as interview, etc.) and Data Analysis(such as Document
Analysis, etc) to determine system’s requirements
[1.5+1.5 =3 marks]
3. Logical Process Modelling, (such as DFD 0, DFD 1, etc.)
[4 marks]
4. Data Modelling and Normalisation (such as ER diagram, etc.)
[4 marks]
The report should be less than 1000 words excluding references and front page.
Sally’s Pet Store Case Study
A young lady with a love for animals is starting a new type of pet store. Sally wants
to match pets with owners who will take good care of the animals. One of her key
objectives is to closely monitor breeders to make sure that they take good care of all
of their animals and that baby animals receive proper care and attention so they will
become friendly pets. A second objective is to develop long-term relationships with
customers. She wants to help them choose the best type of animal for each situation
and to make sure the customers have all of the support and information they need to
properly care for the animals.
Sally realizes that meeting these two objectives requires her to collect and monitor
a large amount of data. After taking an information systems course in an MBA
program she realizes that she needs a database to help her collect data and monitor the
operations of the store.
At the moment Sally has only one store, but she dreams of expanding into
additional cities. She wants to hire and train workers to be “animal friends,” not
salespeople. These friends will help customers choose the proper animal. They will
answer questions about health, nutrition, and pet behavior. They will even be taught
that some potential customers should be convinced not to buy an animal.
Because the workers will spend most of their time with the customers and
animals, they will need technology to help them with their tasks. The new system will
also have to be easy to use, since little time will be available for computer training.
Even based on a few short discussions with Sally, it is clear that the system she
wants will take some time to build and test. Fortunately, Sally admits that she does
not need the complete system immediately. She has decided that she first needs a
basic system to handle the store operations: sales, orders, customer tracking, and basic
animal data. However, she emphasizes that she wants the system to be flexible
enough to handle additional features and applications.
Sally wants to create the application in sections. The first Section will track the
basic transaction data of the store. Hence we need to identify the primary entities
involved in operating a pet store.
The first step in designing the Pet Store database application is to talk with the
owner (Sally), examine other stores, and identify the primary components that will be
needed. After talking with Sally, it becomes clear that the Pet Store has some features
HS2011 Systems Analysis and Design – Trimester 2 2015 2
that make it different from other retail stores. The most important difference is that
the store must track two separate types of sales: animals are handled differently from
products. For example, the store tracks more detailed information on each animal.
Also, products can be sold in multiple units (e.g.. six cans of dog food), but animals
must be tracked individually. An important design feature of the diagram must be that
the animals and merchandise are treated separately.
Because of Sally’s philosophy of providing good homes for the pets, she also
wants to collect detailed information about each customer. Sally also monitors
suppliers more carefully than most store owners. She is even thinking about hiring
people to inspect various breeders. The inspectors would provide reports on a variety
of features, such as cleanliness, number of animals boarded, number of trainers, type
of food served at each meal, and quality of veterinary care.
While talking with Sally, a good designer will write down some of the basic
items that will be involved in the database. This list consists of entities for which we
need to collect data. For example, the Pet Store database will clearly need to collect
data on customers, suppliers, animals, and products. Likewise, we will need to record
each purchase and each sale. Right from the beginning, we will want to identify
various attributes or characteristics of these entities. For instance, customers have
names, addresses, and phone numbers. For each animal, we will want to know the
type of animal (cat, dog, etc.), the breed, their date of birth, and so on. (NB We don’t
sell gold fish or hermit crabs)
Assignment Submission:
Assignment Date Due: Friday Week 10, 2015 by 5:00 PM
Assignment Submission Guideline: Please submit your softcopy online using the
respective BlackBoard assignment submission link. ( In special circumstances, you
can submit hard copy of your assignment in the class to your lecturer or submit your
hard copy of your assignment at Holmes Institute reception ground level, 185 Spring
Street. )
The post HS2011 Systems Analysis and Design appeared first on My Assignment Online.