Question 1: Consider the following College and perform the task that follows. Ocean Sound College, a liberal arts college located on the West Coast, provides dormitory housing for approximately half of its students. Students who choose not to live on campus, or who do not get assigned dormitory space, must find housing in the surrounding community. Currently, the housing office uses a cumbersome system of multiple binders to keep track of housing opportunities for students, faculty, and staff of the college. Housing listings are for college-owned housing, housing owned by private parties including landlords and individuals looking for roommates. The current system is difficult to maintain and keep up-to-date. The new college president approved a request to fund the development of a system to provide easier access and maintenance of listings. You are the systems analyst assigned from the college IT department to conduct the initial investigation into the feasibility of such a system. The preliminary investigation reports resulted in approval for you to proceed with the systems analysis phase. You have already developed data flow diagrams, documented the data stores, and created a data dictionary. Now you are at the point in the analysis phase where you need to describe the processes that will be used in the housing system.

Background Based on your information gathering to date, you have determined the following about a listing system for the housing office at Ocean Sound College: The current listing system revolves around multiple copies of three binders of housing listings. These are separate binders for undergraduate listings, graduate listings, and faculty/staff listings. Within each binder are copies of listings available to a particular group. Listings either are generated by the college housing office from their own housing units, or from private landlords who call the housing office to list housing vacancies. In addition, students or other groups of people who have rooms available in a residence may list the rooms. The data dictionary has been developed to include data elements contained in each listing which includes the following: listing owner (college-owned housing, private landlord, or individual room for rent), type of housing (apartment, house, condo, etc.), square footage, number of bedrooms, number of bathrooms, rent, security deposit, utilities included, handicap features, other features and amenities, date of availability, lease term, multiple lease parties allowed, contact information, and restrictions on rental (smoking, non-smoking, gender, etc). Pet policy data elements include pets accepted, type of pet (cats, small dogs, large dogs, or other), pet fees, and deposits. Each property may be listed in any or all of the binders, to allow the listing party to direct their listing to their target audience. When the college rents a property, the listing is removed from all binders in which it appears. Private landlords are asked to call in when a property is rented to facilitate the removal of that listing from the binders. People using the binders who find housing listings that already have been rented are asked to report those so they can be removed. The binders are reviewed at the end of each month by the housing office staff, and private listings older than 2 months are removed. Based on the results of your information gathering, the next step is to develop a logical model of the proposed listing system. We use process descriptions to explain the logical steps that each process performs. To create these descriptions, we use three tools: structured English statements, decision tables, and decision trees.

Tasks 1. Create a set of structured English statements that accurately describes one process found in this system. 2. Design a decision table for a process in this system with all possibilities. 3. Simplify the table by combining rules where appropriate to demonstrate the logic that will be transformed into program code in the new system. 4. Draw a decision tree that reflects a process used in the system.

Question 2: Consider Nimo Gyagya and Pot Belly business below and reposnd to the questions that follow: Nimo Gyagya and Pot Belly is a family-owned business that operates on the Gulf Coast. The company already uses both financial and point-of-sale (POS) software, but has been unable to find a suitable system to manage its inventory and purchase orders. You are an independent consultant who has been hired to develop an inventory and order system for the company.

Background Nimo Gyagya purchases a variety of seafood (tuna, mackerel, shrimp, eel, crab, etc.) from local fishing boats and fresh vegetables from local farmers to make Gyagya and Pot. Other food products are purchased from an Asian grocery wholesaler. Nimo Gyagya sells its products through a variety of outlets, most notably its restaurant. The company sells prepackaged Gyagya and Pot to supermarkets, hospitals, and other companies for resale. To ensure profitability, the company prices its products based on the estimated material cost that goes into producing them. Restaurant food is sold at cost plus 200 percent, wholesale orders are sold to retailers at cost plus 60 percent and smaller orders including catering events are sold at cost plus 100 percent. Due to the volatility in prices of seafood, menu prices are updated on a regular basis.Currently, the company uses a journal to record its purchases and orders. Any employee can add, edit, or strike out a journal entry. When new seafood or vegetable products arrive, employees must record the type, total weight, and cost as a new journal entry. A spreadsheet is used to keep track of inventory totals. Wholesale and retail prices are manually calculated and entered into the POS software. Inventory is pulled out of stock on a first in, first out basis. As the business continues to grow, this system is becoming less viable. Some of the shortcomings include: 1. Employees sometimes make clerical mistakes or forget to record transactions. 2. When the inventory holds a particular type of seafood or produce that has been purchased at different times and costs, it is difficult to determine the correct cost bases and some older food is spoiling before getting sold because food preparers are taking out stock in the wrong order. 3. Sales prices have to be manually calculated, a process that can take a lot of time to complete.You have completed the systems planning phase; the next step is to create an object-oriented model of the inventory and orders system.

Tasks 1. Create a use case diagram for an inventory and order system. 2. Create a class diagram for classes you would expect to find in Nimo Gyagyas system. 3. Create a sequence diagram for some aspect of the new system. 4. Create a state transition diagram that describes a changing state in the system.

Question 3: Papa Sagacity School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the schools administrative needs.

Background Your preliminary investigation and fact-finding tasks are complete. You join Papa Sagacitys director, for a status update meeting to discuss the progress you have made with the requirements documents you put together. You discuss the system requirements and she is in agreement with you on what you have identified as necessary components of the new system. The new information system will contain components that will register students, generate drop-in reports, generate bills, record payments, generate receipts, and generate monthly reports.The next step is to develop a logical model of the proposed billing system. You explain to her how you will develop data flow diagrams (DFDs) that will be used to graphically show how data input will move through a system and be turned into useful information.

Tasks 5. Prepare a context diagram for the new system. 6. Prepare a diagram 0 DFD for the new system. 7. Prepare a list of data stores and data flows needed for the system. Under each data store, list the data elements required. 8. To help explain to Papa Sagacity the process used to further develop the diagrams into the system model, write a brief memo that explains the importance of leveling and balancing a set of DFDs. Make sure the memo contains the proper formal heading and formatting.