Topic 4&5

Question 1

5 phase of system development life cycle

Answer 1

1. planning
2. analyst
3. design
4. implementation
5. support and security

Question 2

4 activities in planning phase

Answer 2

1. review the request
2. prioritize the request
3. allocate the resources
4. team

Question 3

2 activities in analyst phase

Answer 3

1. conduct an investigation
2. perform detailed analysis
   
   • how current system works
   • user requirements
   • solutions

Question 4

2 activities in design phase

Answer 4

1. acquire software and hardware
2. develop details

Question 5

4 steps to acquire necessary software and hardware

Answer 5

1. identify technical specification
2. solicit vendor proposal
3. test and evaluate vendor proposal
4. make a decision

Question 6

4 activities in implementation phase

Answer 6

1. develop the program and app (if necessary)
2. install and test
3. train user
4. convert to new system

Question 7

4 tests to be performed

Answer 7

1. unit
2. system
3. integration
4. acceptance

Question 8

3 activities in support and security phase

Answer 8

1. maintenance
2. monitor performance
3. access the security

Question 9

difference between compiler and interpreter

Answer 9

compiler: convert the whole source program to a machine language
interpreter: translate and execute one instruction at a time

Question 10

advantages of object oriental programming

Answer 10

1. to implement object
2. create applications faster
3. object can be reused

Question 11

define macro

Answer 11

macro is a series of statement that instruct a program to complete a task

Question 12

4GL

Answer 12

Four-Generation Language
- allow developer to access data in database
- SQL

Question 13

define database

Answer 13

collection of data organized in manner for access, retrieval and use of the data

Question 14

define data

Answer 14

collection of unprocessed items:
- video
- audio
- text
- number
- image

Question 15

define information

Answer 15

processed data that is meaningful, useful and organized

Question 16

4 uses of DBMS (database management system)

Answer 16

• sort and retrieve data
• create form and reports
• add, modify and delete data
• create computerized database

Question 17

4 levels of database

Answer 17

(general to specific)
1. data files
2. record
3. field
4. character

Question 18

primary key and foreign key

Answer 18

primary key: create unique row identification
foreign key: create link between two tables

Question 19

2 main components of database (relational database)

Answer 19

• row: record
• column: field

Question 20

3 data models

Answer 20

1. relational
2. multidimensional
3. object-oriented

Question 21

disadvantages of database

Answer 21

• data can be vulnerable
• complex data require huge storage media
• high cost as the data frequent change

Question 22

advantages of database

Answer 22

• shared data
• easier access
• reduce data redundancy

Question 23

4 techniques to restore database

Answer 23

• backup
• log
• recovery utility
• continuous back up

Question 24

4 tools in DBMS

Answer 24

1. query language - english-like statement to specify data to display, print, store, update or delete
2. query by example - graphical user interface for retrieving data
3. form - area to entering and modify data
4. report writer - to design report