- List out the skills that are required for a system analyst.
- what do you mean by PIECES framework?
- List out the methods of FAST methodology.
- write down the importance of PERT in project management.
- what are the tasks involved in the problem analysis phase?
- List out any 5 fact finding techniques.
- what are the characteristics of good data model?
- how do we construct a process model?
- write some differences between a physical and logical data flow diagram (DFD).
- what do you mean by Economic Feasibility?
- what is PIECES framework for problem Identification?
- what is CASE tool ? what is the use of CASE tool?
- Importance of PERT for project manager?
- what are the technology drivers of information system?
- Explain the business and technology drivers for today`s information system.
- what are the steps to plan a JRP session? Describe.
- Explain the various risk management processes.
- Explain the CRUD matrix with a suitable example.
- what are the benefits of using the object oriented analysis?
- which 3 techniques of feasibility studies are more appropriate in Nepal Government’s software development project and explain why?
- Explain some of the tasks involved in the in-house (the build solution) development approach.
- what is SDLC? Explain the phases of SDLC.
- you are assigned to collect facts about NIST LMS. which 2 methodology do you like to select for fact finding and why.
- List 5 skills of system analyst ? Explain the process of project management.
- Design a 1 level DFD or Possible E-R diagram for the given business case.
a) when customer orders come in, the item master and the customer master files are both updates. if an item is out of stock, the inventory control department is notified.
b) if the order if form a new customer order, a new record is created in the customer master file.
c) Picking slip are produced for the customer order and sent to the warehouse.
d) A shipping statement is prepared.
e) The process of shipping a customer order involves getting the goods from the warehouse and matching up the customer shipping statement, getting the correct customer address, and the shipping it all to the customer.
f) The customer statement is generated and the billing statement is sent to a customer once month.
g) An account receivable report is sent to the accounting department.
Unit: 1 Systems Analysis Fundamentals Short answer questions:
- Compare treating information as a resource to treating humans as a resource.
- What is the use of KWS?
- How MIS do not replace transaction processing system?
- How DSS is similar to traditional information system?
- Which system helps the executives to take decisions?
- Which is the more general term, CSCWS or GDSS?
- How GDSS helps to solve the problem?
- Why user involvement throughout the systems project is necessary?
- Why system analyst needs to be hired in an organization?
- Why is system analysts called as agent of change?
- Which basic qualities must system analysts have to perform its basic roles?
- What are reasons for using CASE tools?
- How agile approach is different from SDLC?
- What are the activities involved in the first stage of SDLC?
- The values such as communication, simplicity, feedback and courage must be adopted while using which software development approach.
- Which phase of agile approach system analyst is using while he is adopting a curious attitude towards the work environment ,its problems, technologies and people?
- What do you understand by the prouctionizing phase of agile approach?
- What are the advantages of TPS over manual system?
- List and explain the higher level systems.
- List the problems of group interaction that GDSS and CSCWS were designed to address.
- Write note on wireless system and open source software.
- Explain needs, roles and qualities of system analyst.
- Explain software development life cycle in brief.
- Explain five stages of agile modelling development process.
- List down four situation under which system analyst choose SDLC and Agile approach.
- List the advantages of using systems analysis and design techniques in approaching computerized information systems for business.
Unit: 2 Information Gathering Short Questions:
- State reasons why system analyst uses open-ended questions.
- List the situations that warrant use of JAD in place of personal organizational interviews.
- “List your top two priorities for improving the technology infrastructure”. State the type of question.
- Which type of questions help in saving time, keeping control over interviews and getting relevant data.
- In which type of questions arrangement, specific questions are asked first then general type of questions and end with a specific questions.
1.The Nokia consultant company wants to update the accounting functions, a maker of digital cameras, you as a system analyst have to interview Mr. Ankit Shah , the chief accountant. Write four to six interview objectives covering his use of decision-making frequency, desired qualities of information, and decision-making style.
a. In a paragraph, write down how you will approach Ankit Shah to set up an interview.
b. State which structure you will choose for this interview. Why?
c. Ankit Shah has four subordinates who also use the system. Would you interview them also? Why or why not?
d. Would you also try to interview customers (visitors to the Web site)? Are there better ways to get the opinions of customers? Why or why not?
e. Write three open-ended questions that you will email to Ankit Shah prior to your interview.
2. Examine the interview structure presented in the sequencing of the following questions:
1.How long have you been in this position?
2.What are your key responsibilities?
3.What reports do you receive?
4.How do you view the goals of your department?
How would you describe your decision-making process?
6.Who is consulted when you make a decision?
7.What is the one decision you make that is essential to departmental functioning?
a. What structure is being used in above questionnaire? How can you tell?
b. Restructure the interview by changing the sequence of the questions (you may omit some if necessary). Label the reordered questions with the name of the structure you have used.
C. Other than above mentioned questions which other questions can you formed for this
Unit: 3 Using Data Flow Diagrams
- What is a Data Flow Diagram? State its use?
- List out any two advantages and disadvantages of Data Flow Diagram.
- State the rules for constructing a context level diagram.
- State the rules for constructing a zero level diagram.
- What is a physical DFD?
- What is a logical DFD?
- Give the key difference between physical DFD and logical DFD.
- For what purpose is a CRUD used?
- How much maximum process does a zero level DFD have?
- Define Data Store.
- What is the purpose of partitioning DFD?
- Compare and contrast context diagram with zero level diagram.
- State any explain the rules of creating zero level DFD with example.
- What is a physical DFD? Explain its advantages in detail.
- Draw a physical DFD for customer order process in supermarket information system.
- Which are the elements of a DFD? Define and explain all of the elements.
- Explain in detail child diagrams.
- What do you mean by partitioning DFD? Describe website partitioning in detail.
- Write a short note on Communicating DFD.
- Draw a DFD for the following:
a) Music Course Management system
“A ballet studio receives an inquiry from a customer. A receptionist logs the inquiry in to an inquiry file, and forwards the inquiry to the facilities planning department and to the scheduling department. The scheduling department coordinator searches the online course catalog file to find a course description that best matches the customer’s needs. The scheduling coordinator then searches the schedule file to find dates and times for that course. Finally, the scheduling coordinator sends the course description along with scheduled dates and times to the customer.”
b) Gym Management System
“Gym Management System is an easy-to-use gym and health club membership management system. It helps you keep records of your members and their memberships, and allows easy communication between you and your members. Gym Master is also feature-packed, helping you in the management and growth of fitness club.”
c) Online Courier Management System
“Courier Management System is a Windows-based solution specifically designed for the courier and parcel delivery industries. Courier Management System automates the in-field courier process such as, inbound and outbound airway bills, delivery run sheets, accounts receivable and real-time courier tracking.
The web-enabled interface allows the user to login from anywhere in the world, and track their courier and also view the customer rate chart. The system is designed to integrate with Financial Accounting, to eliminate duplication of data entry and is also scalable to grow along with your company.”
1.Order & dispatch
4.Billing (Using crystal reports)
5.Accounting reports (Using crystal reports)
Unit: 4 Designing Database
- List some examples of entities and their attributes.
- What is the difference between a primary key and an object identifier?
- Define the term metadata. What is the purpose of metadata?
- Name the three main types of database organization.
- Define the term normalization.
- What is removed when a relation is converted to the first normal form?
- What is removed when a relation is converted from 1NF to 2NF?
- What is removed when a relation is converted 2NF to 3NF?
- List the three entity constraints. In a sentence, describe the meaning of each entity constraint.
- Define denoramalization.
- What are the advantages of organizing data storage as separate files?
- What are the advantages of organizing data storage using a database approach?
- What are the effectiveness measures of database design?
- List types of commonly used conventional files. Which of these are temporary files?
- Describe the four anomalies that may occur when creating database tables.
- List the eight steps for retrieving, presorting and presenting data.
- Explain the differences between traditional database and data warehouses.