ADBMS CHAPTER 6: DATABASE ADMINISTRATION AND SECURITY

The database’s predominant role is to support managerial decision-making at all levels. (Role of Databases)

• Interpretation and presentation of data

• Distribution of data and information

• Preservation and monitoring of data

• Control over data duplication and use

• Produce structured diagrams (DFDs, ERDs, class diagrams, object diagrams)

Three levels of organization management

• Top

• Middle

• Operational

• Support

Structured methodologies and powerful graphical interfaces. Automated framework for SDLC

• Computer-aided Systems Engineering (CASE) Tools

• DBMS facilitates

• Role of Databases

• Data Information Decision Making Cycle

Provide support for planning, analysis, and design phases

• Front-end CASE tools

• Back-end CASE tools

• Role of Databases

• Data Information Decision Making Cycle

Provide support for coding and implementation phases

• Front-end CASE tools

• Back-end CASE tools

• Role of Databases

• Data Information Decision Making Cycle

Produce structured diagrams (DFDs, ERDs, class diagrams, object diagrams)

• Graphic design

• Screen painters and report generators

• Integrated repository

• Analysis segment

Produce the information system’s input and output formats (end-user interface)

• Graphic design

• Screen painters and report generators

• Integrated repository

• Analysis segment

Stores and cross-references the system design data; includes a comprehensive data dictionary

• Program documentation generator

• Screen painters and report generators

• Integrated repository

• Analysis segment

Provide a fully automated check on system consistency, syntax, and completeness

• Program documentation generator

• Screen painters and report generators

• Integrated repository

• Analysis segment

The Fifth CASE Tool Component

• Program documentation generator

• Screen painters and report generators

• Integrated repository

• Analysis segment