Itec | Computer Science homework help

Part A: 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). (10 points)

b) Do link testing with large amounts of data to prove that the system will work. (10 points) 

c) Do full systems testing with large amounts of live data to show that the system is working. (10points)

Respond to each of the three steps in their proposed test schedule. Use a paragraph to explain your response.

Part B: 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? (10 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. (10points)

Problem II – (50 points)

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) Construct a PERT diagram for her and identify the critical path.                            (20 points)

DescriptionTaskMust FollowTime

Interview Executives​  A​   None​  6

Interview staff in orders fulfillment​  B​   None​   3

Design input prototype​  C   ​   B​   2

Design output pro-type​  D​   A,C​   3

Write use cases​  E​   A,C   ​   4

Record staff reactions to prototypes​  F​   D​   2

Develop system​  G​   E,F​   5

Write up training manual​  H   ​   B,G​   3

Train staff working in order fulfillment   I​   H​   2

b) If Cherry could find away to save time on the “write use cases” phase, how would it help? (30points)

Problem III- (50 points)

The problem 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.

As a systems analyst, would you approve this proposal? (The diagram is the proposal)

Please explain the reasons why you support or do not support this proposal. …need to offer some modifications to improve it. 

Problem IV – (50 points)

All Pets Clinic Pharmacy has offered to give you a free lifetime supply of medicine if you design its database. 

Given the rising cost of veterinarian care, you agree. 

The following is the information you gathered:

• Pets are identified by a code #, and their names, addresses, and ages must be recorded• Veterinarians are identified by an SSN. For each veterinarian, the name. specialty, and years of experience must be recorded.• Each pharmaceutical company is identified by name and has a phone number• For each medication, the trade name and formula must be recorded. Each medication is sold by a given pharmaceutical company, and the trade name identifies a medication uniquely from among the products of that company.  Each pharmacy has a name, address, and phone number• 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.• Each pharmacy sells several medications and has a price for each. A medication could be sold at several pharmacies, and the price could vary from one pharmacy to another.• Each medication has a date and a quantity associated with it.  You can assume that, if a veterinarian prescribes the same medication for the same pet more than once, only the last such medication needs to be stored.

1. Draw an ER diagram that captures the preceding information.  Identify any constraints not captured by the ER diagram (10pts.)

2. How would your design change if each medication must be sold at a fixed price by the pharmacies?  (Requirement: Provide a written explanation) (20pts.)

3. How would your design change if the design requirements change as follows:  If a veterinarian prescribes the same medication for the same petmore than once, several such prescriptions may have to be stored? (Requirement: Provide a written explanation) 20pts.

Problem V – (50 points)

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 Number

Student Name

Total Credits

GPA

Advisor Number

Advisor Name

Course Number

Course Description

Course Credits

Grade

1034

Linda

47

3.60

59

Smith

CSC101

Computer Science I

4

B

MKT211

Marketing Management

3

A

ENG101

English Composition

3

B

CHM111

General Chemistry I

4

A

BUS101

Introduction to Business

2

A

3397

Sam

29

3.00

59

Smith

ENG101

English Composition

3

A

MKT211

Marketing Management

3

B

CSC101

Computer Science I

4

B

4070

Kelly

14

3.20

23

Jones

CSC101

Computer Science I

4

B

CHM111

General Chemistry I

4

A

ENG101

English Composition

3

B

BUS101

Introduction to Business

2

B

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.







Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

New Look, Same Us. Enjoy 10% OFF this October using the coupon code: essay10