Unit 12 : Database Development Life Cycle Flashcards
1
Q
What is the process of Systems Analysis?
A
- Process that establishes need for and extent of information system
2
Q
What is the process of Systems Development?
A
- Process of creating information system
3
Q
What does Information System provides? ( 3 )
A
- Data Collection
- Storage
- Retrieval
4
Q
What does the information system composed?
A
- Hardware
- Software
- Database
- Application
- Programs
- Procedures
5
Q
What does Applications do in information system?
A
- To process and transform data into information that forms basis for decision making
6
Q
What does Applications outputs in the Information System? ( 3 )
A
- Format Report
- Tabulations
- Graphic Displays
6
Q
What does the Applications in Information System is composed of? ( 2 )
A
- Data
- Code by which data are transformed into information
7
Q
What are the factors for Information System Performance depends of?
A
- Database Design and Implementation
- Application Design and Implementation
- Administrative Procedures
8
Q
What is the primary objective of database development?
A
- To create a complete, normalized, nonredundant ( to the extent possible ) and fully integrated conceptural, logical and physical database models
9
Q
What is the process database development ?
A
- The process of database design and implementation
10
Q
What does system development life cycle traces?
A
- Traces history ( life cycle ) of information system
11
Q
What does system development life cycle provides?
A
- Provides “big picture” within which database design and application development can be mapped out and evaluated
12
Q
List out the 5 phases for Systems Development Life Cycle
A
- Planning
- Analysis
- Detailed Systems Design
- Implementation
- Maintenance
13
Q
Is the 5 phases of System Development Life Cycle a sequential process?
A
- No, it was a iterative process
- Means that it will be doing again and again, and usually to improve it
14
Q
List out the 2 actions on the Planning phase
A
- Initial Assessment
- Feasibility Study
15
Q
List out 3 actions on the Analysis phase
A
- User Requirements
- Existing System Evaluation
- Logical System Design
16
Q
List out 1 actions on the Detailed System Design phase
A
- Detailed system specification
17
Q
List out 2 actions on the Implementation phase
A
- Coding, Testing and Debugging
- Installation, Fine-tuning
18
Q
List out 3 actions on the Maintenance phase
A
- Evaluation
- Maintenance
- Enhancement
19
Q
What is the next step for the final phase which is Maintenance?
A
- Perform a loop back to the first phase which is Planning
20
Q
What does Planning phase yields?
A
- General overview of company and its objectives
21
Q
What does Initial Assessment made of in Planning phase?
A
- Information-flow-and-extent requirements
22
Q
What must be studied and evaluate alternate solutions in Planning phase? ( 2 )
A
- Technical aspects of hardware and software requirements
- System cost
23
Q
What phases of problems are being examinated in greater detail during analysis?
A
- Analysis Phase
- Existing Hardware and Software Systems are studied
- Thorough audit of user requirements
24
What is the goal of Analysis phase?
1. Better understanding of system's functional areas, actual and potential problems, and opportunities
25
What are going to be included in the creation of logical system design in Analysis phase?
1. Must specify appropriate conceptual data model, inputs, processes, and expected output requirements
2. Might use tools such as data flow diagrams (DFDs), hierarchical input process output (HIPO) diagrams, and entity relationship (ER) diagrams
3. Yields functional descriptions of system’s components (modules) for each process within database environment
26
Who completed design of system's processes in Detailed Systems Design phases?
1. Designer
27
What does Detailed Systems Design phase includes?
1. All necessary technical specifications
28
List out the other actions that will be done in Detailed Systems Design phase? ( 2 )
1. Steps are laid out for conversion from old to new system
2. Training principles and methodologies are also planned
29
What are installed and implemented in the Implementation phases?
1. Installed
- Hardware
- DBMS Software
- Application Programs
2. Implemented
- Database Design
30
What are the list of cycle before the database is ready to be delivered? ( 3 )
1. Coding
2. Testing
3. Debugging
* Database is created and system is customized by creation of tables and views, and user authorizations
31
List out the 3 groups for maintenance activities in Maintenance phases
1. Corrective maintenance in response to systems errors
2. Adaptive maintenance due to changes in business environment
3. Perfective maintenance to enhance system
* Also make it possible to produce better systems within reasonable amount of time and at reasonable cost
32
List out the 6 phase of Database Life Cycle ( DBLC )
1. Database Initial Study
2. Database Design
3. Implementation and Loading
4. Testing and Evaluation
5. Operation
6. Maintenance and Evaluation
33
List out the 4 actions for Database Initial Study phases in Database Life Cycle
1. Analyze the company situation
2. Define the problems and constraints
3. Define objectives
4. Define scope and boundaries
34
List out the 4 actions for Database Design phases in Database Life Cycle
1. Create the conceptual design
2. DBMS software selection
3. Create the logical design
4. Create the physical design
35
List out the 3 actions for Implementation and Loading phases in Database Life Cycle
1. Install the DBMS
2. Create the database(s)
3. Load or convert the data
36
List out the 3 actions for Testing and Evaluation phases in Database Life Cycle
1. Test the database
2. Fine-tune the database
3. Evaluate the database and its application programs
37
List out the 1 action for Operation phases in Database Life Cycle
1. Produce the required information flow
38
List out the 2 action for Maintenance and Evolution phases in Database Life Cycle
1. Introduce Changes
2. Make Enhancements
39
What are the processes required to complete first phase of DBLC successfully?
1. Interactive and Iterative processes
40
How to analyze the company situation?
1. Discover what company's operational components are, how they function, and how they interact
41
What are the general conditions of Company Condition?
1. General conditions in which company operates, its organizational structure, and its mission
2
42
What is the process of analysis?
1. To break up any whole into its parts so as to find out their nature, function and so on
43
What view of company's operation if often different form that of end users?
1. Managerial View
44
What is important to find in Define Problems and Contraints in Database Life Cycle?
1. Finding precise answers
* Defining problems does not always lead to perfect solution
45
What must carefully be done by designer in Define Problems and Constraints in Database Life Cycle?
1. Designer must continue to carefully probe to generate additional information that will help define problems within larger framework of company operations
46
What things that designer must ensure in Define Objectives in Database Life Cycle?
1. Designer must ensure that database system objectives correspond to those envisioned by end user(s)
47
What are the questions that the designer must begin address in Define Objectives in Database Life Cycle? ( 3 )
1. What is proposed system's initial objective?
2. Will system interface with other existing or future systems in the company?
3. Will system share data with other systems or users?
48
What does Scope defines in Database Life Cycle?
1. Extent of design according to operational requirements
2. Helps define required data structures, type and number of entities, and physical size of database
49
What does Boundaries does in Database Life Cycle?
1. Limits external to system
* It is often imposd by existing hardware and software
50
What doe DBLC describes?
1. The history of database within the information system
* Database design and implementation process moves through series of well-defined stages
