Hello, I need help as soon as possible, if that’s possible
University of Maryland University College ITEC 630 Section 1141-1509
Final Essay Exam
Wednesday, November 18, 2015 The Final is due by 11:59 pm EST Wednesday, November 25, 2015.
This is an open-book individual exam comprised of 6 questions. Please answer all 6
? Put your name in the exam.
? You should submit your exam to your assignment folder in WebTycho in a MS-Word,
MS-RTF, PDF or ASCII file. Please scan your file against viruses before submitting.
? Please keep the full text of the question as part of your answering sheet.
? Be as clear and objective as you can in all questions and be sure you are answering
what is asked.
? Justify all your numerical answers and answer all the questions using your own
words. Show all your work, including how you found your answer (this is very
important and essential to have your answer graded appropriately!). Make sure that you read, acknowledge, and follow the following rules
? The exam is to be taken in accordance with the UMUC Honor Code ? e.g., do not
collaborate or seek help from anyone else.
? This is an open-book exam but you are only allowed to use your textbook and
information posted in our classroom. Please do not use any other sources that are not
listed in our classroom. For example, you can refer to our class lecture notes and all
links posted in the lecture notes but you should not search the Web for information to
solve exam questions.
? You should not discuss exam questions with other students or anyone else. If you have
any questions about the exam, you can send me e-mail to [email protected] Acknowledge:
I, _____________________________ acknowledge the above rules.
(Your name) Problem I – (50 points)
Part A: You and your ITEC 630 Group Project Team are close to completing a system
for Meecham Feeds. Ms. Taylor Swift, who is one of your ITEC 630 teammates, is quite
confident that the programs that she has written for Meecham?s inventory system will
perform as necessary, because they are similar to programs she has written 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; Taylor Swift has agreed). (6 points)
b) Do link testing with large amounts of data to prove that the system will work. (6
c) Do full systems testing with large amounts of live data to show that the system is
working. (14 points)
In the form of a well crafted essay, please respond to each of the three steps and their
proposed test schedule.
Part B: Mr. Bruce Schnieder, the owner of A&A Office Supplies Company, had
contacted you and your ITEC 630 Group Project Team for your advice on a new
information system installed recently at his company to help improve 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 particular fiscal 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 advice on his decision and on the evaluation of
his new system.
a) In a well crafted essay response, please explain to Mr. Schnieder about problems
that can occur when a system is not evaluated systematically? (6 points)
b) Devise a formal 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 in the form
of a well crafted essay response. (18 points) c) Problem II – (50 points)
The following is a code for one produce in an extensive cosmetic line:
L02002Z621289. L means that it is a lipstick, 0 means that it was introduced without
a matching nail polish, 2002 is a sequence code indicating in what order it was
produced, Z is a classification code indicating that the product is hypoallergenic, and
621289 is the number of the plant (there are 15 plants) where the product was
PART A: In the form of a well crafted essay response, please critique the above
code by listing the features that might lead to inaccurate data entry. (24 points)
PART B: Write a well crated essay response which explains changes that you have
suggested, indicating what data entry problems the change will eliminate. Please
include your version of the revised code in your response. (26 points) Problem III- (100 points)
Mr. Robert Griffin III, who represents one of the many U. S. distributors of the
European soft drink ?Drew-izzle?, gazes unhappily at a newspaper weather map,
which is saturated with dark red, indicating that most of the United States is
experiencing an early Spring heat wave with no signs of a let up.
Pointing to the paper as he speaks, Mr. Robert Griffin III tells you and your ITEC 630
Group Project Team ?It?s the best thing that could happen to us, or at least it should
be. But when we had to place our orders three months ago, we had no idea that this
Spring monster heat wave was going to devour the country this way!?
Nodding his head toward a picture of their European plant on the wall, he continues.
?We need to be able tell them when things are hot over here in the United States so
we can get enough product. Otherwise, we?ll miss out every time. This happened to
us two years ago and it just about killed us. People want their Drew-izzle on a hot,
sunny day. It?s so dang refreshing!! Like an overtime win against the Dallas
Cowboys during Monday Night Football.?
?Each of us distributors meets with our district managers to do three month planning.
When we agree, we fax our orders into European Headquarters. They make their
own adjustments, bottle the zero calorie and oh so refreshing Drew-izzle, and then
we get our modified orders about 9 to 15 weeks later. But we need ways to tell them
that what?s going on now. With our new retail distribution agreement with WALMART, our European Headquarters should know that we have extra-high demand
and it will only keep getting bigger as more Americans fall in love with that zero
calorie, sweet, and refreshing bottle of Drew-izzle. Yummy?.it?s just a very delicious
carbonated beverage. The Drew-izzle puts the fizzle back into carbonated
beverages. Even the bottle is nice. It?s nicer than Tom Brady?s hair on Super Bowl
Mr. Kirk Cousins, who is Mr. Griffin?s assistant, agrees, saying ?Yeah, they should at
least look at our past sales around this time of year. Some Springs are hot, others
are just average.?
Mr. Griffin concurs, saying ?It would be music to my ears, kinda like hearing ?Hail to
the Redskins? play after a deep TD pass reception against the Pittsburgh Steelers?
defense, if they could work with us to spot trends and changes, and then respond
IMAGINE!!! Incorporated, based in Liverpool, England, is a European beverage
maker and developer and producer of the zero calorie and oh so refreshing Drewizzle. In Europe, everyone knows that Drew-izzle puts the fizzle back into
carbonated beverages. Drew-izzle makes drinking soda fun & cool again. Drewizzle?..we put the fizzle back into soda!
IMAGINE!!! Incorporated has had a difficult time adequately managing inventory and keeping up with the U.S. customer demand, which is affected by seasonal
temperature fluctuations. Places with year-round, warm temperature climates and
lots of tourist (such as Florida and California) have large standing orders, but other
areas of the country could benefit from a less cumbersome, more responsive order
placing process. Drew-izzle is distributed by a network of local distributors, who are
located throughout the United States and Canada.
IMAGINE!!! Inc. is looking for a systems solution that will address the problem and
the solution should stress collaboration, flexibility, adaptability, and access. The
solution should not cost the company no more than $7.5 million US Dollars to
implement and must be fully operational in exactly twelve calendar months. One of
your ITEC 630 Group Project Team members proposed the following simple network
solution (as discussed in Figure 16.9, Figure 16.10, Figure 16.11, and Figure 16.11)
that is to create an intranet that links the U.S. distributors with the European
Centers Intranet European
Processing PART A: As depicted in Figure 3.2, please create a problem definition for
IMAGINE!!! Incorporated to include identifying all of the issues, objectives,
requirements, and constraints that were listed in this entire scenario. You can
take creative liberties when establishing and assigning the weights to each of the
PART B: As a systems analyst, respond to this proposal, via a well crafted
essay, by answering the following question: ?Does this proposed network solve
the problem mentioned above?? 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 the above network
decomposition diagram. (see Figure 16.9, Figure 16.10, Figure 16.11, and
Figure 16.11) Problem IV – (15 points)
The database table layout of an ordering system is illustrated Figure 13.24 (Kendall &
Kendall, page 381), please draw an E-R diagram for the ordering system. (15 points) Problem V – 35 points)
PART A: By way of a well crafted essay response, please define and explain (to
include your own examples) the Theory of Reasoned Action, the Theory of Planned
Behavior and the Technology Acceptance Model (10 points). I want a fluid story not
three distinct paragraphs. Connect the dots, how did we go from the Theory of
Reasoned Action to the Technology Acceptance Model? PART B: A U.K. ?based travel agent, Tony Blair, LLC would like your systems team to
design a command-language interface he can use to book seats for airliners to which
his firm has solid business ties, such as British Air, Ryan Air, and Virgin-Atlantic.
a) Make a list of commands needed to book an airline seat and write down what
each command means. (15 points)
b) Show what the interface would look like on a smartphone display. (10 points) Problem VI – (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.
Credits GPA Advisor
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 ENG101 English Composition 3 A MKT211 Marketing Management 3 B CSC101 Computer Science I 4 B CSC101 Computer Science I 4 B CHM111 General Chemistry I 4 A ENG101 English Composition 3 B BUS101 Introduction to Business 2 B 3397 4070 Sam Kelly 29 14 3.00 3.20 59 23 Smith Jones 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 & explain each step along the way and identify
primary keys, if any, in each table in each step. Please explain your work as you make
the progression from 1NF to 3NF. I would like for you to explain everything you?re doing
as you move from First Normal Form to Third Normal Form.