Do full systems testing with large amounts of live data to show that the system is working.
The Final is due by midnight (11:59 PM) Sunday, 12-3-2017. This is an open-book individual exam comprised of 5 questions. Guidelines: ● 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 Rules:
● 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. ● Note: Do not post multiple files. The exam should be posted in one file.
Acknowledge: I, __ _____ acknowledge the above rules. (Your name)
Problem I – (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.
Problem II – (50 points)
Part A: Your systems analysis team is close to completing a system for Friendly Feeds. Robert is quite confident that the programs that he has written for Friendly’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; Robert 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. (10 points)
Respond to each of the three steps in their proposed test schedule. Use a paragraph to explain your response.
Part B: Mr. Frank Fickle, the owner of Fickle 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. Fickle about problems that can occur when a system is not evaluated systematically? (10 points)
b) Devise a checklist or form that helps Mr. Fickle’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. (10 points)