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)
2. Data Gathering( such as interview, etc.) and Data Analysis(such as Document Analysis, etc) to determine system's requirements
3. Logical Process Modelling, (such as DFD 0, DFD 1, etc.)
4. Data Modelling and Normalisation (such as ER diagram, etc.)
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 withcustomers. 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 willanswer 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 shewants 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 flexibleenough 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 beneeded. 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 thatthe store must track two separate types of sales: animals are handled differently fromproducts. 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 animalsmust 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 eports on a variety of features, such as cleanliness, number of animals boarded, number of trainers, typeof 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 identifyvarious attributes or characteristics of these entities. For instance, customers have names, addresses, and phone numbers. For each animal, we will want to know theype of animal (cat, dog, etc.), the breed, their date of birth, and so on. (NB We don't sell gold fish or hermit crabs)