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