Question 1:

a) Define unit testing, integration testing, and system testing.

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?

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.

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:

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:

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"
2. Explode the above context-level diagram by drawing the logical data flow diagram level 0 showing all the major processes.

Question 4:

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:

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

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.