System Analysis and Design - Phase III. A - Introduction

Which of the following activities is usually carried out in the Design phase

• Implement decision trees in Python
• Determine the suitable programming language to implement decision trees
• Create decision tables for elementary processes
• Create decision trees for elementary processes

Which of the following is not a Design phase activity

• Create physical DFD and ERD models
• Define hardware and software specifcation
• Define process logic specification
• Estimate database size

Which of the following refers to the 'outsourcing' Design Strategy

• To pay SAP (an IT consulting firm) to develop a payroll system
• To pay Booking.com for using its platform to manage hotel bookings
• To pay existing employees on a Java crash-course so they can develop the company website

Which is not a good reason for buying packaged software and tailor them for an information system

• To save time
• To benefit from existing support
• To train staff for in-house technical expertise

Which is least likely a risk with outsourcing as a Design Strategy compared to in-house development

• Possibility of losing confidential data
• Difficulty with future development
• Increased cost of the project

Consider the following names for elements on a physical DFD. Which is not appropriate

• A data flow name "HTML form: Order details"
• A process name "Calculate order price: Java"
• A data store name "Customer"
• An external agent "Customer"

Which are possible activities in developing physical ERDs

• Define data types and size of attributes
• Add a system required field to the Loan entity to record the timestamp of each loan record
• Split the Customer table into two smaller tables for performance improvement
• All of the other three

Which is NOT one of the four basic operations on persistence storage

• Delete
• Create
• Undelete
• Retrieve

Given the CRUD matrix for the process shown in the picture, which operation is not to be done by this process

• Get existing borrower details
• Get existing DVD details
• Add a new loan record for the borrower
• Delete previous loans of this customer