Databases-Chap 10 Flashcards
Database design
The systems development life cycle(SDLC)
Traces history(life cycle) of an IS , provides “big pic” within which the database design and application development can be mapped out and evaluated
Six phases (SDLC)
1)Planning
2)Analysis
3)Detailed systems design
4)Implementation
5)Operation
6)Maintenance
Planning
-Initial assessment
-Feasibility study
Analysis
-User requirements
-Existing system evaluation
-Logical system design
Design
-Detailed system specification
Implementation
-Coding, testing and debugging
-Installation, fine-tuning
Operation
-Produce the required information flow
-Help desk support
-Monitoring of performance
Maintenance
-Evaluation
-Maintenance
-Enhancement
The database life cycle(DBLC) phases
1)DB initial study
2)DB design
3)Implement and load
4)Testing and evaluation
5)Operation
6)Maintenance and evolution
DB initial study purpose:
-Analyze the company situation
-Define problems and constraints
-Define objectives
-Define scope and boundaries
DB design
-Create the conceptual design
-DBMS software selection
-Create the logical design
-Create the physical design
Implement and load
-Install the DBMS
-Create the databases
Load/convert the data
Testing and evaluation
-Test the database
-Fine-tune the database
-Evaluate the DB and its application programs
Operation
-Produce the required info flow
Maintenance and evolution
-Introduce changes
Make enhancements
Systems analysis
Is the process that establishes the need for and the scope of an IS
Systems development
The process of creating an IS
The performance of an IS depends on a triad of factors:
-Database design and implementation
-Application design and implementation
-Administrative procedures
Database development
Describes the process of database design and implementation
objective:
create complete, normalized, non-redundant(to the extent possible) and fully integrated conceptual ,logical and physical database models
Centralized design
Is productive when the data component is composed of a relatively small number of objects and procedures
Decentralized design
Might be used when the data component of the system has a considerable no of entities and complex relations on which very complex operations are performed
IS
An IS provides for data collection, storage and retrieval, it also facilitates the transformation of data into information and the management of both data and information
