Question 1 of 5: (20 points)
a)Define unit testing, integration testing, and system testing. (3 points)
b)You are a systems analyst at ABC Inc. Company and you are a project leader of a team that is developing a new production monitoring system for a client. Your team completed the unit testing and the integration testing and is preparing to start the system testing which is scheduled for the next three weeks. Your manager, Joe Smith, who is under a lot of management pressure, wants to deliver the system to the client within several days. He approached you and asked if you could trim system testing from three weeks to five days. Your manager requested that you write to him a brief memo to your manager expressing your views.
Question: As a system analyst, you know that is not a good decision. Therefore, what do you include in your brief memo for your views regarding your manager’s decision to trim down the system testing time? (7 points)
c) You are a project manager at L & D Inc., specialized in information technology and network engineering. One of your junior systems analyst came to you for an advice of a technology to capture user information requirements. He described to you that he had talked with his client several times in the past week to define user information requirements. Each time he thought he had captured user information requirements, they’ve already changed. Finally, he thinks his clients do not even know what they want for their system.
Give your junior systems analyst an advice of a technology that he could use to capture user information requirements and explain to him how this technology can help him to better define users’ information requirements. (10 points) 
*** For this question, please limit you response to a maximum of one page.
Clarification:
Students should take the word "technology" as being defined in several dictionaries as a scientific method, technique, theory, or practice to solve a practical problem. I copy here some definitions of the word "technology" from several dictionaries that you might refer to answer your question. 
1. The application of science, especially to industrial or commercial objectives.
2. The scientific method and material used to achieve a commercial or industrial objective. 
3. The application of practical sciences to industry or commerce.
4. The methods, theory, and practices governing such application a highly developed technology. 
1. The use of scientific knowledge to solve practical problems, especially in industry & commerce.
2. The specific methods, materials, and devices used to solve practical problems. 


Question 2 of 5: (10 points)
Michael, who is a restaurant owner, wants to be able to receive clear feedback on the systems used to manage his restaurants.
Design a display that shows an acceptable way to tell Michael that input to his system was accepted. Make sure that all three types of following of feedback messages are covered.
1.Action successful.
2.An error in the user entry.
3.Please wait messages, indicating that a response time of more than 5 to 10 seconds will elapse.


Question 3 of 5: (25 points)
A summary of business activities of a “Course Registration System” for enrolling courses for students and for enrolled class lists for faculty members at an online university is as follows:
An academic department provides information on offered courses. Students request enrollment in offered courses and the system sends to each student an enrollment schedule. Faculty members receive enrolled class lists when the registration period is complete.
1. Draw a context-level data flow diagram for the “Course Registration System” (10 points)
2. Explode the above context-level diagram by drawing the logical data flow diagram level 0 showing all the major processes (15 points)


Question 4 of 5: (20 points)
Draw an entity-relationship diagram (ERD) in the third normal form for a “student database record” system based on the following situation:
•A student may register for many courses, and a course may have many students.
•A student may have many professors, and a professor may teach many students.
•A student is assigned only one counselor, but each counselor usually has many students.
Identify relationships among the diagram entities as “one-to-one” and/or “one-to-many”, if any. Identify entities as “entity” or “associative entity”.
***Note that for the third normal form ERD, any of its many-to-many relationships must be converted into two one-to-many relationships using associative entities. For this question, assume that there are attributes associated with the relationship so it is okay to model a many-to-many relationship with an associative entity.


Question 5 of 5: (25 points)
Consider the following agent sales report in which:
1.Each agent covers only one state but each state may be assigned to many agents
2.Each agent may have many customers
3.Each customer has only one store but each store may service many customers
4.There is a one-to-one correspondence between “Customer ID” and “Customer Name” and between “Store ID” and “Store Location”.

AGENT-SALES-REPORT
Agent IDAgent NameAgent
Covered StateCustomer IDCustomer NameStore
IDStore LocationSales Amount
A100120Alexander GabayVirginiaC504181Jones Smith312Richmond12000
A100120Alexander GabayVirginiaC504182Kelly Walker312Richmond2000
A100125Marc ThomasOregonC167120Frank Barnes465Elkton5000
A432102Allen MaysCaliforniaC017215William Kelly978Los Angeles3000
A432102Allen MaysCaliforniaC017216Bruce Kents900Santa Ana43000
A236100George BrownFloridaC246911Hilton Jackson201Miami15000
A901227Amy HartleyMarylandC303554James Phillips315Baltimore25000

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.

 

University of Maryland University CollegeITEC 630Fall 2016 - 9040Final ExamMonday November 28, 2016The Final is due by midnight (11:59 PM) Sunday, December 04, 2016.This is an open-book individual exam comprised of 5questions.Guidelines:Put your name in the exam.You should submit your exam to your assignment folder in LEO in a MS-Word or PDF file.Please scan your file(s) 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 andessential to have your answer graded appropriately!).Make sure that you read, acknowledge, and follow the following rulesRules:The exam is to be taken inaccordance with the UMUC Honor Code– e.g., do not collaborateor seek help from anyone else.This is an open-book exam but you are only allowed to use your textbook and information postedin our classroom. Please do not use any other sources that are not listed in our classroom.Forexample, you can refer to our class lecture notes and all links posted in the lecture notes but youshould 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 anyquestions about the exam, you can send me e-mail todaniel.le@faculty.umuc.edu.Acknowledge:I, __________________________________________ acknowledge the above rules.(Your name)

Attachments:

• 1494210529-ITEC-630-Final-Exam-Fall-2016.doc