QuestionQuestion

Transcribed TextTranscribed Text

1) Your systems analysis team is close to completing a system for Meecham Feeds. Roger is quite confident that the programs that he has written for Meecham’s inventory system will perform as necessary, because they are similar to programs he has done before. Your team has been very busy and would ideally like to begin full systems testing as soon as possible. Two of your junior team members have proposed the following: a) Skip desk checking of the programs (because similar programs were checked in other installations; Roger has agreed). (6 points) b) Do link testing with large amounts of data to prove that the system will work. (6 points) c) Dofullsystemstestingwithlargeamountsoflivedatatoshowthatthe system is working. (14 points) Respond to each of the three steps in their proposed test schedule. Use a paragraph to explain your response. 2) Mr. Bruce Schnieder, the owner of A&A Office Supplies Company, had contacted you for your advices on a new information system installed recently at his company to help improving his company inventory tasks. He told you that the team that came to install the system does not have any evaluation mechanism and he also mentioned to you that some of his employees had complained about the new system’s inputs and outputs. Since he wants to obtain the inventory result of this quarter, he would like to delay or skip the new system evaluation and use the new system for inventory right away. Given the above conditions, he would like to have your advices on his decision and on the evaluation of his new system. a) In a paragraph, explain to Mr. Schnieder about problems that can occur when a system is not evaluated systematically? (6 points) b) Devise a checklist or form that helps Mr. Schnieder’s employees evaluate the utilities of the new information system. Suggest a second way to evaluate the information system, if any. Please be specific and explain your answers. (18 points) 3) Cherry Jones owns a homeopathic medicine company called Faithhealers. She sells vitamins and other relatively nonperishable products for those who want choices regarding alternative medicine. Cherry is developing a new system that would require her staff to be retrained. a) Given the information in Figure 3.EX3 (Kendall & Kendall, page 102), make a PERT diagram for her and identify the critical path. (24 points) Description Task Interview Executives A Interview staff in orders fulfillment B Design input prototype C Design output protype D Write use cases E Record staff reactions to prototypes F Develop system G Write up training manual H Train staff working in order fulfillment I Must Follow Time None 6 None 3 B 2 A,C 3 A,C 4 D 2 E,F 5 B,G 3 H 2 b) If Cherry could find away to save time on the “write use cases” phase, would it help? Why or why not (26 points) 4) The problem (refer to Consulting Opportunity 3.1) is that the orders are not easily placed to the European plant, which is compounded whenever demand for the products increases dramatically. The company is looking for a systems solution that will address the problem and the solution should stress collaboration, flexibility, adaptability, and access. One of your systems analyst team members proposed the following simple network solution that is to create an intranet that links the U.S. distributors with the European headquarters. Distribution Centers Intranet European Plant Production Control Order Processing As a systems analyst, respond to this proposal by answering the following question: “Does this proposed network solve the problem mentioned in Consulting Opportunity 3.1?” If the answer is “Yes”, please explain the reasons why you support this proposal. Otherwise, explain the reasons why you disagree with the proposal and in case you are not completely agree with the solution, please offer some modifications to improve it. 5) The Prescriptions R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here is the information that you gatherer: • Patients are identified by an SSN, and their names, addresses, and ages must be recorded • Doctors are identified by an SSN. For each doctor, the name. specialty, and years of experience must be recorded. • Each pharmaceutical company is identified by name and has a phone number • For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company is deled, you need not keep track of its products any longer. • Each pharmacy has a name, address, and phone number • Every patient has a primary physician. Every doctor has at least one patient • Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another. • Doctors prescribe drugs for patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity associated with it. You can assume that, if a doctor prescribes the same drug for the same patient more than once, only the last such prescription needs to be stored. • Pharmaceutical companies have long-term contracts with pharmacies. A pharmaceutical company can contract with several pharmacies, and a pharmacy can contract with several pharmaceutical companies. For each contract, you have to store a start date, an end date, and the text of the contract. • Pharmacies appoint a supervisor for each contract. There must always be a supervisor for each contract, but the contract supervisor can change over the lifetime of the contract. 1. Draw an ER diagram that captures the preceding information. Identify any constraints not captured by the ER diagram 2. How would your design change if each drug must be sold at a fixed price by all pharmacies? (Requirement: Provide a narrative explanation) 3. How would your design change if the design requirements change as follows: If a doctor prescribes the same drug for the same patient more than once, several such prescriptions may have to be stored? (Requirement: Provide a narrative explanation) 6) Consider a school advising system in which a faculty advisor can advise many students, each of whom can register for one or many courses. The following is an example of an un-normalized STUDENT table for three students. STUDENT Student Student Number Name 1034 Linda 3397 Sam 4070 Kelly Total GPA Credits 47 3.60 29 3.00 14 3.20 Advisor Advisor Course Number Name Number 59 Smith CSC101 Course Description Computer Science I Course Grade Credits 4 B 3 A 3 B 4 A 2 A 3 A 3 B 4 B 4 B 4 A 3 B 2 B MKT211 Marketing Management ENG101 English Composition CHM111 General Chemistry I BUS101 Introduction to 59 Smith ENG101 Business English Composition MKT211 Marketing Management CSC101 Computer Science I BUS101 Introduction to Business 23 Jones CSC101 Computer Science I CHM111 General Chemistry I ENG101 English Composition Perform the normalization process to convert the above un-normalized table to: 1. First normal form (1NF). 2. Second normal form (2NF). 3. Third normal form (3NF). Please show all your work. Please show each step along the way and identify primary keys, if any, in each table in each step.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

1) Your systems analysis team is close to completing a system for Meecham Feeds. Roger is quite confident that the programs that he has written for Meecham’s inventory system will perform as necessary, because they are similar to programs he has done before. Your team has been very busy and would ideally like to begin full systems testing as soon as possible

Two of your junior team members have proposed the following:

a) Skip desk checking of the programs (because similar programs were checked in other installations; Roger has agreed).

Desk Checking is a method to check the logic of an algorithm by manually working through it.
 Reasons why Desk Checking may be omitted or simplified:
• If the current program’s logic is identical, then this step may be omitted; this, however, implies some effort to verify “sameness.” If truly identical, perhaps there is re-usable code, or the code to be developed should become a reusable [library] routine.
• If it is [very] similar, then the variances should be documented and those cases should be desk checked.
• If there are testing tools, high speed compilers, and adequate processing power, automated approaches to unit testing may be as effective.
 Reasons why Desk Checking should be considered, even when logic is “similar” to past efforts
• There is a natural human tendency to want to short-cut testing steps, especially when tight deadlines loom; performing the desk check may reinforce a valuable discipline.
• If another coder is responsible for the logic, it forces that additional programmer to become intimately knowledgeable, and this spreads expertise.
• Often, a tested code block is in use for a period of time and a specific condition does not arise (testing mitigates but does not eliminate this). For critical functions, another desk check may catch something overlooked in the past.
b) Do link testing with large amounts of data to prove that the system will work. (6 points)
Link Testing is the testing of a group of modules to ensure that the modules operate correctly in combination. It typically verifies that a function or process is executed properly.
Here, the nature of the test data is more important than its volume. The test data set must cover all conditions which affect proper functioning to verify proper execution and gracefully handle exceptions and error conditions. For simpler functions and/or few modules, high volumes may not be required.
c) Do full systems testing with large amounts of live data to show that the system is working.
System Testing is a type of testing to confirm that the system/product works as a...

By purchasing this solution you'll be able to access the following files:
Solution.docx.

$60.00
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Computer Science - Other Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats