Chapter 9 :
List and briefly explain the three steps performed during the physical design stage.
- Define data storage organization: Defines tables, indexes, and views physical organization -Define integrity and security measures: defines users, security groups, roles and access controls Determine performance measures: define database and query execution parameters
List and briefly explain the four steps performed during the logical design stage.
-Map conceptual model to logical model components: define tables, columns, relationships and constraints -Validate logical model using normalization: normalized set of tables . -Validate logical model and integrity constraints: ensure entity and referential integrity; define column constraints -Validate logical model against user requirements: ensure the model supports user requirements
How do systems analysis and systems development fit into a discussion about information systems?
-Systems analysis is used to determine the need for an information system and to establish its limits. Within systems analysis, the actual information system is created through a process known as systems development. -the Systems Development Life Cycle (SDLC), which is a continuous process of creation, maintenance, enhancement, and replacement of the information system.
What is an information system? What is its purpose?
A system that provides for data collection, storage, and retrieval; facilitates the transformation of data into information; and manages both data and information. An information system is composed of hardware, the DBMS and other software, database(s), people, and procedures. A system that provides for data collection, storage, and retrieval; facilitates the transformation of data into information; and manages both data and information. An information system is composed of hardware, the DBMS and other software, database(s), people, and procedures.
What does the acronym DBLC mean, and what does a DBLC portray?
The acronym DBLC stands for Database Life Cycle. This cycle traces the history of a database within an information system. The cycle is divided into six phases: initial study, design, implementation and loading, testing and evaluation, operation and maintenance, and evolution.
What does the acronym SDLC mean, and what does an SDLC portray?
The acronym SDLC stands for the Systems Development Life Cycle (SDLC). The SDLC portrays the history of an information system. The traditional SDLC is divided into five phases: planning, analysis, detailed systems design, implementation, and maintenance. The SDLC is an iterative process rather than a sequential process.