a) be looking for when hiring their new

a)      What qualifications should the systems analysis team be looking for when hiring their new ecommerce development team member? (3 points)

The qualifications are as follow:

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

a.       Good in programming

b.      Good understanding of Web (programming languages)

c.       Translate business requirements into design and coding must understand

d.      Experience working in the field of Ecommerce

e.       Web platforms

f.        Being able to communicate effectively

g.      Finally, interpersonal skills as well as technical skills.

b)     Is it more important to know specific languages or to have an aptitude for picking up languages and software packages quickly? (3 points)

Yes, it is certainly essential to know specific languages for Ecommerce and furthermore imperative to have an aptitude for picking up new languages too. Because, knowing specific languages or having an aptitude for picking up languages/software packages is to be sure necessity to be a successful as a system analyst.

c)      What basic busi­ness skills should the new team member have? (3 points)

Business savvy, decision making skills, and case tools.

d)     How should the new team member be different from the existing team members in terms of competencies and skills? (2 points)

Grasps the strategic importance of the Web and know basic accounting, inventory, and distribution of goods and services, too.

e)      What personality or character traits are desirable in a systems analyst who will be working in ecommerce development? (4 points)

Good personality and who fits in well, should be able to communicate well and with business clients. The system analyst should be a self-motivated, self-disciplined person who can work with and manage a team. Further, System Analyst should be a problem solver and should have a better understanding of human-computer interactions and professional ethics. Finally, System Analyst should able to understand of how systems are put together, design skills, and skills related to coding and testing.

 

Problem II – (20 points)

Use the process of normalization to transform the table below into 3NF. Show the tables in 1NF and 2NF that are created in the process.

 

Business ID

Business Name

Business City

Car Model(s)

F100

Fred Autos

Galveston

F150, F350

G100

George Trucks

San Antonio

F150

H100

Henry Wheelers

Dallas

W1000

F101

Fred Autos

Galveston

F250

 

1NF:

Business ID

Business Name

Business City

Car Model(s)

F100

Fred Autos

Galveston

F150

F100

Fred Autos

Galveston

F350

G100

George Trucks

San Antonio

F150

H100

Henry Wheelers

Dallas

W1000

F101

Fred Autos

Galveston

F250

2NF:

B_ID

Business Name

Business City

Car Model(s)

1

Fred Autos

Galveston

F150, F350

2

George Trucks

San Antonio

F150

3

Henry Wheelers

Dallas

W1000

4

Fred Autos

Galveston

F250

                                               

                                                Table 1 (B_ID is the primary key)

B_ID

Business ID

1

F100

2

G100

3

H100

4

F101

                                                                        Table 2

 

3NF

B_ID

Business Name

Business City

Car Model (S)

1

Fred Autos

Galveston

F1535

2

George Trucks

San Antonio

F15

3

Henry Wheelers

Dallas

W1

4

Fred Autos

Galveston

F25

                                                Table 1 (Car Model is the foreign key)

 

B_ID

Business ID

1

F100

2

G100

3

H100

4

F101

                                                                        Table 2

 

Model _ID

Car Model

F1535

F150, F350

F15

F150

W1

W1000

F25

F250

                                                                        Table 3

Problem III – (15 points)

Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is purchased from many vendors. The bakery has commercial customers, such as schools and restaurants, and private customers that regularly place orders for baked goods. Each baked good has a specialist that oversees the setup of the bakery operation and inspects the finished product that they are responsible for.

 

Problem IV – (20 points)

White-N-Wheat Bread Company has asked for your help in comparing its present computer system with a new one its board of directors would like to see implemented. Proposed system and present system costs are as follows:

 

      Year                      Proposed System Costs                      Present System Costs

      Year 1

Equipment Lease        $20,000                                   $21,500

Salaries                         40,000                                     50,000

Overhead                        4,000                                     13,000

Development                 21,000                                         —

 

     Year 2       

Equipment Lease        $20,000                                   $10,500

Salaries                         43,000                                     55,000

Overhead                        1,000                                       3,300

Development                 12,000                                         —

 

     Year 3

Equipment Lease        $20,000                                   $10,500

Salaries                         36,000                                     60,000

Overhead                        4,900                                       3,600

Development                     —                                             —

 

     Year 4

Equipment Lease        $20,000                                   $10,500

Salaries                         39,000                                     66,000

Overhead                        5,500                                       4,000

Development                    —                                              —

 

Using break-even analysis, determine the year in which White-N-Wheat Bread will break even with these two strategies.

Year

Item

Proposed System Costs

Present System Costs

1

Equipment Lease

20000

21,500

2

Equipment Lease

20,000

10,500

3

Equipment Lease

20,000

10,500

4

Equipment Lease

20,000

10,500

1

Salaries

40,000

50,000

2

Salaries

43,000

55,000

3

Salaries

36,000

60,000

4

Salaries

39,000

66,000

1

Overhead

4,000

13,000

2

Overhead

7,000

3,300

3

Overhead

4,900

3,600

4

Overhead

5,500

4,000

1

Development

30,000

0

2

Development

12,000

0

3

Development

0

0

4

Development

0

0

 

Break-even happens between Year2 and Year3.

 

Graph the costs and show the break-even point.

 

 

 

Problem V – (15 points)

Eat-Ur-Potatoes is a fast-food restaurant offering all kinds of potatoes. The manager has a 30-second time limit for serving customers. Servers at the counter say they could achieve that limit if the form they must fill out and give to the kitchen were simplified. The information from the completed form is entered into the computer system at the end of the day, when the data entry person enters the kind of potato purchased, additional toppings purchased with their quantities, and the price charged. The current form is difficult for servers to visually scan and fill out quickly.

Design and draw a form that lists possible potatoes and toppings in a manner that is easy for counter servers and kitchen crew to visually scan, and can also be used as input to the inventory system that is on the extranet connecting Eat-Ur-Potatoes and Idaho potato growers. Choose a size that is sensible and be sure to indicate the size of the form if it is not drawn at full-scale. You may use MS Word to produce this form if you don’t have any other drawing software available. You won’t be judged on the aesthetics of the form, just the content and layout. Be sure to observe the guidelines for good form design.

Kinds of potatoes

Toppings

Qty

Price

Laura potato

Onions

 

$50

King Edward potato

Extra cheese

 

$150

Kerr’s pink

Bacon

 

$120

Kennebec potato

Mushroom

 

$30

Russet Burbank

Green peppers

 

$30

Salad potato

Black olives

 

$50

Dore

Sour cream

 

$80

 

Design and draw a representation of a display screen that can be used by the servers and clerks to fill in the information captured on the form. Again, you may use MS Word for this purpose.

Potatoes

Price

Laura Potato
King Edward potato
Kerr’s pink
Kennebec
Russet Burbank
Saland potato
Dore

$30
$80
$70
$20
$20
$25
$50

Toppings
Onions
Extra cheese
Bacon
Mushroom
Green peppers
Black olives
Sour cream

Price
$20
$70
$50
$10
$10
$25
$30

 

Design and draw a display screen based on your screen in part b. This time it should function as a display that shows a kitchen crew member what to prepare for each order. List three changes to the screen in part b that you made to adapt it to function as an output display. You may use MS Word to show the layout of the screen.

 

Potatoes

Experience

Crew member

level

Laura Potato
King Edward potato
Kerr’s pink
Kennebec
Russet Burbank
Saland potato
Dore

Student -intern
Student – intern
5 years experienced
4 years experienced
5 years experienced
3 years experienced
1-2 years experienced

John
Mary
Marshal
Anto
Sheena
Peter
Selvam
 
 

5
5
5
5
5
5
5
 

 

 

 

 

Problem VI – (15 points)

As part of a larger systems project, Capital Bank of Nowhere, Colorado, wants your help in setting up a new monthly reporting form for its checking and savings account customers. The president and vice presidents are very attuned to what customers in the community are saying. They think that their customers want a checking account summary that looks like the one offered by the other three banks in town. They are unwilling, however, to commit to that form without a formal summary of customer feedback that supports their decision. Feedback will not be used to change the prototype form in any way. They want you to send a prototype of one form to one group and to send the old form to another group.

 

a.    In a paragraph discuss why it probably is not worthwhile to prototype the new form under these circumstances.

 

The two reasons for why prototyping the new form is not advisable are given below:

            The president and vice presidents are agreed to what their customers in the community are saying. In this example, the customers clearly would like to have a checking account summary is similar to the other three banks introduced in town.

            The bank management would require to have a formal summary of customer feedback that supports their decision about the new form. However, feedback will not be used to change the prototype form in any way.

Therefore, for the above mentioned two reasons, it is not advisable to prototype the new form.

 

b.   In a second paragraph discuss a situation under which it would be advisable to prototype a new form.

If the bank management willingly commits to the new form with a formal summary of customer feedback and the feedback to make adjustments to the proposed from such format and layout, then it would be advisable to prototype a new form.