94%(18)17 out of 18 people found this document helpful
This preview shows page 2 - 6 out of 9 pages.
organizationsStrategic DecisionsExecutive InformationSystemsTactical DecisionsManagementInformation SystemsOperationalDecisionsTransactionProcessing Systems
EntireOrganizationIndividual-Strategic InformationSystems-info systems that provide competitive advantage1) Strategic Business Planning-know WHO you are-strategy determined-mission and vision statement2) IS Assessment-know what you HAVE or where you START-resources identified3) IS Vision-know WHERE you want to GO-how IS is going to help accomplish the strategy4) IS Architecture -know HOW you can get there-technical plan to implement IS vision5) IS Strategic Initiatives-know WHAT you need to do-specific thrusts to accomplish objectives-Evaluating Strategic Initiatives-prioritizing initiatives and evaluate using priority matrix-Potential returns ease of implementation Broad ApplicationIntegration withinReports from TPS aidManagement (MIS)Captures Daily Data Events (TPS)Office Automation (OA)Ease of ImplementationPotential Returns
Data, Information, and Databases-Data-Collection of unprocesseditems-text, numbers, images, audio, video-Metadata-data that describes the properties of other data-example: header of a table-hierarchy of data-organized in layers1) data tables-collection of related records 2) Record-group of related fields-uses primary key to identify each record3) Field-combo of one or more related characters-must have=field name, size, & data type4) Character -one or money bytes (numbers, letters, etc.)-data is made up of characters-Information-processed data
-Databases-Collection of data organizedin a manner that allows access & retrieval of data-designed, & built for specific purpose-database software (access)-Database Management System (DBMS)-allows users to:-created a computerized database-add, modify, delete, sort, & retrieve data-create forms and reports from the data -Database Administration Terminology-Database-collection of tables containing info to support a given system-Entities-things that we store info about (people, places, etc.)-Table-collection of records for a given entity-Records-a row in access-individual people have a personal record -a group of fields or attributes to describe a single instance of an entity (rows)`-Field-characteristics/attributes about entity-also called attributes depending on DBMS -pieces of info about entities (name, ID)-columns in access-Data Modeling-Graphical depiction of the relationship between data-Entity Relationships Diagrams (ERD) is a type of data model-Associative Entities