ITEC 630 Problems, assignment help

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!).Problem I  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 Meechams 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 points) 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 systems 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)Devise a formal checklist or form that helps Mr. Schnieders 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)Problem II  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 produced. 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  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 Its 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, well 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. Its 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 whats going on now. With our new retail distribution agreement with WAL-MART, 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.its just a very delicious carbonated beverage. The Drew-izzle puts the fizzle back into carbonated beverages. Even the bottle is nice. Its nicer than Tom Bradys hair on Super Bowl Sunday. Mr. Kirk Cousins, who is Mr. Griffins 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 quickly.  IMAGINE!!! Incorporated, based in Liverpool, England, is a European beverage maker and developer and producer of the zero calorie and oh so refreshing Drew-izzle. In Europe, everyone knows that Drew-izzle puts the fizzle back into carbonated beverages. Drew-izzle makes drinking soda fun & cool again. Drew-izzle..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 headquarters. 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 issues. 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  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  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.  Make a list of commands needed to book an airline seat and write down what each command means. (15 points)Show what the interface would look like on a smartphone display. (10 points)Problem VI  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 & 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 youre doing as you move from First Normal Form to Third Normal Form.