Chapter 9

Get Started. It's Free
or sign up with your email address
Rocket clouds
Chapter 9 by Mind Map: Chapter 9

1. 9.1 The Information System

1.1. The information system is where data collection, storage, and retrieval takes place.

1.2. System analysis is the process which is needed for an information system and its extent. It is important that the strategic value is within an information systems.

1.3. There are three factors of performance within a information system which include: database design and implementation, application design and implementation, administrative procedures.

2. 9.2 The Systems Development Life Cycle

2.1. Systems Development Life Cycle (SDLC) is able to trace the history of the information system.

2.2. Planning is an important phase of SDLC which yields a general overview of the company and objectives.

2.2.1. Anaylsis looks more into the problems that are defined in the planning phase. The design phase completes the design of the systems processes. The implementation phase, is the hardware, software, and applications systems installed.

3. 9.3 The Database Life Cycle

3.1. DBLC has six phases: Database initial study, database design, implementation and loading, testing and evaluation, operation, and maintenance and evolution.

3.2. Overall purpose of a database initial study is the analyze the company situation, define the problem and constraints, define objectives, and define the scope and boundaries.

4. 9.4 Conceptual Design

4.1. This is the first stage in the database design process. The main goal is to design the database so that it independent of the database software and physical details.

4.2. Minimal data rule: all that is needed is there, and all that is there is needed.

4.3. Description of operations is a formal document that is derived from business rules, it provides up-to-date,precise, description of activities.

5. 9.5 DBMS Software Selection

5.1. It is critical to the information systems to enable smooth operation. Both the advantages and disadvantages should be studied carefully.

5.2. To reduce and avoid false expectations, the end user must be aware of the limitations that are in both the DBMS and database.

6. 9.6 Logical Design

6.1. It is the second stage of the database design process. The enterprise wide database based off certain data that is independent of any physical-level details.

6.2. It is important to validate the model using normalization, integrity constraints, and against user requirements.

7. 9.7 Physical Design

7.1. This is the process of determining the data storage organization as wells the data access characteristics of the database to ensure the integrity, security, and performance.

8. 9.8 Database Design Strategies

8.1. There are two classical approaches: Top-down design which is the data sets which defines the elements for each set.

8.1.1. The second is bottom-up design which identifies the data elements and then groups them together into data sets.

9. 9.9 Centralized vs. Decentralized Design

9.1. Centralized is a productive when a data component has a small number of objects and procedures. It is meant for simple, small databases.

9.2. Decentralized is used when the systems data component has a considerable number of entities and relations that are complex which is where complexed operations are performed.