Management Information Systems (MIS)

Planning for, and development, management, and use of information technology tools to help people perform tasks related to information processing and management

Any computer-based tool that people use to work with information and support information and information-processing (i.e. cell phone)

Working outside the main office using communication technologies

Buying and selling using information technologies that coordinate customers, consumers, and companies

Collective information about your customers, competitors, your business partners, your competitive environment, and your internal operations - that gives you the ability to make effective, important strategic business decisions

Gathering of input information, processing of that information, and updating of existing information to reflect the gathered and processed information; database that supports it is OLTP

Rules that help ensure the quality of the information

Helps to specify the logical organization for a database and to access and use the information with a database. Five important steps:1. DBMS engine (accepts logical requests from the various other DBMS systems, converts them into their physical equivalent and accesses the database and data dictionary as they exist on a storage devise)2. Data definition subsystem (helps create and maintain the data dictionary and define the structure of the files in a database)3. Data Manipulation subsystem (helps you add, change, delete information in a database and query it for valuable information)4. Application generation subsystem (contains facilities to help you develop transaction intensive applications)5. Data Administration subsystem (helps manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management.

Relational Database - uses a series of logically related two-dimensional tables or files to store information in the form of a database.Step 1: Define entity classes and primary keysStep 2: Define relationships among entity classesStep 3: Define information (fields) for each relationStep 4: Use a data definition language to create your database

Graphical method of representing entity classes and their relationships

A collection of data that you organize and access according to the logical structure of that data

A person, place, thing about which data is being collected.Data Entity (i.e. employees) - a group of related data recordsData Record - a group of related data fieldsData Field (i.e. name) - an attribute of the entity

A process that improves relational databases design: reduces redundancy, increases maintainability, places attributes in correct entitiesDelete many-to-many relationships!!

A primary key that consists of more than one field

1. Intelligence (find what to fix)2. Design (find fixes)3. Choice (pick a fix)4. Implementation (apply fix)