IS 2080C Prof Rapine Week 3 Notes
IS 2080C Prof Rapine Week 3 Notes IS 2080C
Popular in IS 2080C
verified elite notetaker
Popular in Business
This 2 page Class Notes was uploaded by Brady Zuver on Wednesday September 7, 2016. The Class Notes belongs to IS 2080C at University of Cincinnati taught by Prof.Rapien in Fall 2016. Since its upload, it has received 15 views. For similar materials see IS 2080C in Business at University of Cincinnati.
Reviews for IS 2080C Prof Rapine Week 3 Notes
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 09/07/16
IS 2080C Professor Rapine Week 3 Notes Chapter 3 Data and Knowledge Management and Plug IT in 3 Big Data Companies collect more data than they can analyze and use 1. Managing Data a. Difficulties of Managing Data i. Data is exponentially increasing over time and is scattered throughout organizations ii. Obtained through multiple Internal, Personal and External Sources iii. New sources of data arise and data degrades over time (Data Rot) iv. Security quality and integrity of data is crucial, however easily jeopardized v. Systems do not communicate with each other leaving room for inconsistencies vi. Federal Regulations on data b. Data Governance i. An Approach to managing information across an entire organization involving a formal set of clear rules for creating, collecting, handling and protecting information. ii. Master Data Management 1. A strategy of data governance that provides companies with the ability to store, maintain, exchange and synchronize a company’s Master Data iii. Master Data 1. A set of core data that spans the enterprise information system a. Customer, product, employee, vendor, geographic location, etc. 2. The Database Approach a. Database Management System (DBMS) i. will minimize the following 1. Data redundancy, data isolation, data inconsistency ii. Will maximize the following 1. Data security, data integrity, data independence (from applications) b. Data Hierarchy i. Bit (Binary Digit): represents the smallest unit of data a computer can process, consists of only 0 and 1 ii. Byte: A group of 8 buts that represents a single character (letter, number or symbol) iii. Field: A column of data containing a logical grouping of characters into a word or small group of words (last name, social security number etc) iv. Record: A logical grouping of related fields in a row (a name, course taken, the date and the grade) v. Data File: Logical grouping of records, called a data file or a table similar to an Excel spreadsheet with multiple columns and rows vi. Database: Logical grouping of related data files (database tables) c. Database Management Systems i. DBMS collection of programs to store, delete, access and analyze data ii. Relational database model 1. Structured Query Language (SQL) 2. Query by Example (QBE) d. Database Relationships i. Database Management Systems (DBMS): A set of programs that provide users with tools to create and manage a database ii. Relational Database Model: Based on two dimensional tables that contain records (in rows) and attributes (in columns) iii. Data Model: A diagram that represents the relationships between entities in the database iv. Entity: A person, place, thing or event v. Record: Describes an entity in an instance and refers to each row in a relational table vi. Attribute: Each characteristic or quality of a specific entity vii. Primary Key: A field in a database that can uniquely identify each record to be used viii. Secondary Key: Has some identifying information, but does not identify the record with complete accuracy ix. Foreign Key: a field (or group) that uniquely identifies a row of another table 1. Used as a link between two tables
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'