Topic 4&5 Flashcards
5 phase of system development life cycle
- planning
- analyst
- design
- implementation
- support and security
4 activities in planning phase
- review the request
- prioritize the request
- allocate the resources
- team
2 activities in analyst phase
- conduct an investigation
- perform detailed analysis
- how current system works
- user requirements
- solutions
2 activities in design phase
- acquire software and hardware
- develop details
4 steps to acquire necessary software and hardware
- identify technical specification
- solicit vendor proposal
- test and evaluate vendor proposal
- make a decision
4 activities in implementation phase
- develop the program and app (if necessary)
- install and test
- train user
- convert to new system
4 tests to be performed
- unit
- system
- integration
- acceptance
3 activities in support and security phase
- maintenance
- monitor performance
- access the security
difference between compiler and interpreter
compiler: convert the whole source program to a machine language
interpreter: translate and execute one instruction at a time
advantages of object oriental programming
- to implement object
- create applications faster
- object can be reused
define macro
macro is a series of statement that instruct a program to complete a task
4GL
Four-Generation Language
- allow developer to access data in database
- SQL
define database
collection of data organized in manner for access, retrieval and use of the data
define data
collection of unprocessed items:
- video
- audio
- text
- number
- image
define information
processed data that is meaningful, useful and organized
4 uses of DBMS (database management system)
- sort and retrieve data
- create form and reports
- add, modify and delete data
- create computerized database
4 levels of database
(general to specific)
1. data files
2. record
3. field
4. character
primary key and foreign key
primary key: create unique row identification
foreign key: create link between two tables
2 main components of database (relational database)
- row: record
- column: field
3 data models
- relational
- multidimensional
- object-oriented
disadvantages of database
- data can be vulnerable
- complex data require huge storage media
- high cost as the data frequent change
advantages of database
- shared data
- easier access
- reduce data redundancy
4 techniques to restore database
- backup
- log
- recovery utility
- continuous back up
4 tools in DBMS
- query language - english-like statement to specify data to display, print, store, update or delete
- query by example - graphical user interface for retrieving data
- form - area to entering and modify data
- report writer - to design report
