Integration e Vertical Different Levels of production ex:Oil Company o Horizontal Retail Stores ex: Wal-Mart
l Vertical – Different Levels of Production – ex: Oil Company l Horizontal – Retail Stores – ex:Wal-Mart
Steps Toward Business Process Redesign Develop Business Vision and Process Objectives Prioritize Objectives and Set Targets Identify Process to Be Redesigned Identify Critical or Bottleneck Processes Understand and Measure Existing processes Identify Current Problems and Set Baseline Identify Information Technology Levers Brainstorm new Process Approaches Design and build a Prototy pe of the Process Implement Organizational and Technical Aspects
Develop Business Vision and Process Objectives Understand and Measure Existing Processes Identify Process to Be Redesigned Design and Build a Prototype of the Process Identify Information Technology Levers Prioritize Objectives and Set Targets Identify Critical or Bottleneck Processes Identify Current Problems and Set Baseline Brainstorm new Process Approaches Implement Organizational and Technical Aspects
Database Management Structure o Develop structure of each record according to selected data model o load data into database Update records in database o Generate reports from data in database o Maintain integrity of data in database o Maintain security by means of multilevel passwords
l Develop structure of each record according to selected data model l Load data into database l Update records in database l Generate reports from data in database l Maintain integrity of data in database l Maintain security by means of multilevel passwords
Database Management System Functions o Data Definition Language (DDL o Data Manipulation Language(DML) Query Language ● Report Writer ● Graphics Generator o Host Language Interface(HLD) ● Procedural Language o Data Dictionary
l Data Definition Language (DDL) l Data Manipulation Language (DML) l Query Language l Report Writer l Graphics Generator l Host Language Interface (HLI) l Procedural Language l Data Dictionary
Logical Model o Entity-Relationship Diagram Entities Relationships Between Entities Data normalization Process of eliminating data redundancies and functional dependencies within the logical model
l Entity-Relationship Diagram – Entities – Relationships Between Entities l Data Normalization – Process of eliminating data redundancies and functional dependencies within the logical model