COB 204 Notes Week 2
COB 204 Notes Week 2 COB 204
Popular in Computer Information systems
Popular in Statistics
This 2 page Class Notes was uploaded by Hannah Schwenk on Sunday September 11, 2016. The Class Notes belongs to COB 204 at James Madison University taught by John Karabelas in Fall 2016. Since its upload, it has received 18 views. For similar materials see Computer Information systems in Statistics at James Madison University.
Reviews for COB 204 Notes Week 2
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 09/11/16
COB 204 Notes 9/5 – 9/9 Development in the IS workplace o IS is built for business professionals o Take an active role in specifying system requirements to ensure the system meets the need of your company Managing Information System o Difficult and Complex Strategic Value Acquiring, Operating and Maintaining Constant evolution of IS Information o Knowledge derived from data, recorded as facts and figures o Meaningful Context Necessary Data Characteristic o Accurate o Relevant o Timely o Barely Sufficient (No info overload) o Cost efficient Functional Area o Different IS departments within a firm Dashboard o Traceable data set up to benefit the business user Purpose of a Database o Organize and keep track of data o Keep track of multiple themes Single Theme o Store in a Spreadsheet Multiple Themes o Store in a database Difficulties of Data Storage o Data amounts increase exponentially over time o Data is scattered throughout an organization o Data is generated by multiple sources o Constant new sources of data o Changing legal requirements for data storage Database Management Systems should MINIMIZE o Redundancy o Data Isolation o Data Inconsistency Database Management Systems should MAXIMIZE o Data Security o Data Integrity o Data Independence Data Hierarchy o Record/Row o Field/Box o Byte o Bit Key (primary key) o A column or group of columns that identifies a unique row in a table o Every table must have a primary key Foreign Key o Columns outside of the primary key Metadata o Data that describes other data DBMS operations o Read o Insert o Modify/Update o Delete o Provides tools to assist in administration of the database