Outline Context for database development Goals of database

Outline • Context for database development • Goals of database development • Phases of database development

Intro to Information Systems Concepts Feedback Control Raw materials Manufacturing Products

What is an information system? • An information system is a system that accepts data resources as input, and processes them into information products as output.

Information system model

Components of an Information System Hardware resources ( Machines and media)

Components of an Information System • Data resources • Databases • Knowledge bases • Software resources • Programs • procedures

Components of an Information System People Resources (End users and IS specialists)

Roles in the Database Environment l. Data and database administrators l. Database designers l. Application l. End-Users programmers

Data Administration • Develop and maintain policies governing data access and ownership. • Conduct organizational data resource requirements • Develop organizational data models and architectures • Prepare strategic and technical database plan • Identify potential for data sharing and potential database applications • Set and enforce operational procedures and standards

Database Administration • Conduct physical design • Conduct database tuning and capacity planning • Establish and maintain a data dictionary • Evaluate and select database hardware and software

Database designers • Identification of data and the relationships between the data, and the constraints on the data that has to be stored in the database. • Conceptual database design • Logical database design • Physical design • Defining any security measures required on the data

Types of Information Systems Decision Support Systems Management Information Systems Transaction Processing Systems

Traditional Life Cycle