Monday, August 1, 2016

To-Do 8/1/16

To-Do

Audience Analysis

  • One page
  • Description of Who the Audience is
    • Their background information
    • What is everyone's role
  • Description of Who you Are
    • Your background information
    • What is your role
  • Where Everyone is
  • What are the Circumstances of our meeting

Real World Outline

Tuesday, July 26, 2016

Information Systems HTML Notes

Notes Link
http://www.w3schools.com/html/default.asp


Information Systems Chapter 7, 8, 9 Notes


Chapter 7
  • What are the basic types of processes?
    • Structured Processes
      • Definition
        • Formally defined , standardized processes that involve day to day operations.
    • Dynamic Processes
      • Definition
        • Flexible, informal, and adaptive processes that normally involve strategic and less structured managerial decisions and activities.
    • Work Group Process
      • Definition
        • Process that exists to enable work groups to fulfill the charter, purpose, and goals of a particular group or department.
      • Work Group Information Systems
        • Definition
          • Support one or more processes within the work group.
        • Also known as
          • Functional Information Systems
            • The program component of a functional information system is called a....
              • Functional application
    • Enterprise Processes
      • Definition
        • Processes that span an organization and support activities in multiple departments.
      • Enterprise Information Systems
        • Definition
          • Support one or more enterprise processes.
    • Inter-enterprise processes
      • Definition
        • Processes that span two or more independent organizations. 
      • Inter-enterprise Information Systems
        • Definition
          • Support one or more inter-enterprise processes.
  • How can information systems improve process quality?
    • Process Efficiency
      • Definition
        • Measure of the ratio of process outputs to inputs.
    • Process Effectiveness
      • Measure of how well a process achieves organizational strategy. 
    • Ways in Which Processes May Be Improved
      • Change the Process Structure
        • Reorganize the processes by reordering the tasks
      • Change the Process Resources
        • Change Allocation of Resources
        • Identify Source Delays, and add more resources.
          • Adding resources decreases source delays
      • Change Both the Process Structure and Resources
    • Ways in Which Information Systems Improve Process Quality
      • Performing an activity (Process Activity)
        • Partially automated
        • Completely automated
      • Augmenting a Human Performing an Activity
        • Common reservation system
      • Controlling Data Quality Process Flow
        • Ensure that data values are correct
        • Ensure that data is complete
        • Ensure steps are performed on schedule
        • Makes Correct Process Routing Decisions
  • How do information systems eliminate the problems of information silos?
    • Information Silo
      • Definition
        • The condition that exists when data are isolated in separated information systems.
      • Problems of Information Silos
        • Data Integrity
          • Definition
            • Organization has inconsistent or duplicated data.
        • How do you solve the problems of information silos?
          • Integrate the data into a single database and revise applications to use that database.
  • How do CRM, ERP, and EAI support enterprise processes?
    • The Need For Business Process Engineering
      • Business Process Reengineering
        • Definition
          • The activity of altering existing and designing new business processes to take advantage of new information systems.
    • Emergence of Enterprise Application Solutions
      • Inherent Processes
        • Definition
          • Pre-designed procedures for using the software products, saved organizations from the expense, delays, and risks of business process re-engineering.
    • Customer Relationship Management
      • Customer Relationship Management System
        • Definition
          • A suite of applications, a database, and a set of inherent processes for managing all the the interactions with the customer, from lead generation to customer service.
      • Customer Life Cycle
        • Definition
          • The cycle of marketing, customer acquisition, relationship management, and loss/churn.
    • Enterprise Resource Planning (ERP)
      • Definition
        • Suite of applications called modules, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform.
      • Modules
        • Definition
          • Another name for ERP Application programs
      • ERP System
        • Definition
          • Information system based on ERP technology.
        • Primary Purpose
          • Integration, by allowing the left hand of the organization to know what the right hand of the organization is doing.
        • What can They Do?
          • Display the current status of critical business factors to managers and executives.
    • Enterprise Application Integration (EAI)
      • Definition
        • Suite of software applications that integrates existing systems by providing layers of software that connect applications together.
      • What Does EAI do?
        • Connects system islands via a new layer of software/system
        • Enables existing applications to communicate and share data
        • Provides integrated information
        • Leverages existing systems
          • Leaves functional applications as is, while providing an integration layer over the top.
        • Enables a gradual move to ERP
  • What are the elements of an ERP system?
    • What should the applications of a true ERP system Integrate?
      • Supply Chain
      • Manufacturing
      • CRM
      • Human Resources
      • Accounting
    • ERP Databases
      • Trigger
        • Definition
          • Computer program stored within the database that runs to keep the database consistent when certain conditions arise.
      • Stored Procedure
        • Definition
          • Computer program stored in the database that is used to enforce business rules.
    • Business Process Procedures
      • Process Blueprints
        • Definition
          • Inherent processes that are defined in the ERP solution.
    • Training and Consulting
      • Train the Trainer
        • Definition
          • ERP training curricula and numerous classes in which vendors train employees to act as Super Users, who then train other employees in order to reduce cost.
    • Industry Specific Solutions
      • Definition
        • Industry-Specific Solutions
          • Starter kits for specific industries that include database configuration files and process blueprints that apply to ERP implementation in specific industries.
  • What are the challenges of implementing and upgrading enterprise information systems?
    • The Challenges
      • Collaborative Management
      • Requirements gaps
        • Definition
          • What an organization requires versus what an application can actually do.
      • Transition Problems
        • Transitioning requires careful planning and substantial training.
      • Employee Resistance
        • Employees fear change because it threatens their Self Efficacy.
          • Self Efficacy
            • Definition
              • Person's belief that he or she can be successful at his or her job.
  • How do inter-enterprise IS solve the problems of enterprise silos?
    • Distributed Systems
      • Definition
        • Applications processing is distributed across multiple
      •  What do they do?
        • Enable programs to receive data from, and display data to, a variety of mobile and desktop devices.

Chapter 8
  • What is a social media information system?
    • Social Media
      • Definition
        • Use of information technology to support the sharing of content among networks of users.
    • Social Media Information System
      • Information system that supports the sharing of content among networks of users.
        • SMIS Roles
          • Social Media Providers
            • Definition
              • Platforms enable the creation of social relationships among people with common interests.
          • Users
            • Definition
              • Individuals and organizations that use social media sites to build social relationships .
          • Communities
            • Definition
              • Groups of people related by a common interest.
        • SMIS Components
          • Hardware
          • Software
          • Data
            • Content Data
              • Data and responses to data that are contributed by users.
            • Connection Data
              • Data about relationships
          • Procedures
          • People
  • How do SMIS advance organizational strategy?
    • Dynamic
        • Definition
          • Its flow cannot be designed or diagrammed.
    • Social Media and the Sales and Marketing Activity
      • Social CRM 
        • Definition
          • Dynamic, SM-based CRM process.
      • Social Media and Manufacturing and Operations
        • Crowdsourcing
          • Definition
            • Dynamic social media process of employing users to participate in product design or product redesign.
        • Businesses to Consumer
          • Defintion 
            • Relationships to market products to end users.
        • Business to Business
          • Definition
            • Manufactures using social media to become industry leaders and promote brand awareness.
  • How do SMIS increase social capital?
    • Capital
      • Definition
        • Incestment of Resources For Future Profit
    • Human Capital
      • Definition
        • Investment in human knowledge and skills for future profit.
    • Social Capital
      • Definition
        • Investment in social relations with the expectation of returns in the marketplace.
    • The Value of Social Capital
      • Social Capital Adds Value In These Four Ways
        • Information
          • Definition
            • Information concerning opportunities, alternatives, problems, and other factors important to business professionals.
        • Influence
          • Definition
            • Influence decisions makers who are critical to your success.
        • Social Credentials
          • Definition
            • Being linked to a network of highly regarded contacts.
        • Personal Reinforcement
          • Definition
            • Reinforces professional identity, position, and image in an organization or industry.
    • Value of Social Capital
      • Definition
        • The number of relationships in a social network, the strength of those relationships, and the resources controlled by each relationship.
    • Using Social Networking to Increase the Number of Relationships
      • Influencer
        • Definition
          • Their opinion may force a change in others' behavior and beliefs.
    • Using Social Networks to Increase the Strength of Relationships
      • Strength of a Relationship
        • Definition
          • Likelihood  that the other entity in the relationship will do something that benefits the organization.
    • Using Social Networks to Connect to Those with More Resources
      • Social Capital = Number of Relationships x Relationship Strength x Entity Resources
  • How do (some) companies earn revenue from social media?
    • You Are the Product
      • Monetize
        • Definition
          • Make Money From
    • Revenue Models for Social Media
      • Advertising
        • Pay Per Click
          • Definition
            • Revenue model in which advertisers display ads to potential customers for free and pay only when the customer clicks.
        • Use Increases Value
          • Definition
            • More people use a site, the more value it has, and the more people will visit it.
        • Freemium
          • Definition
            • Revenue model offers users a basic service for free and then charges a premium for upgrades or advanced features.
          • Ad-Blocking Software
            • Definition
              • Used by web users to filter out advertising content and rarely, if ever, see internet ads. 
    • Does Mobility Reduce Online Ad Revenue?
      • Conversion Rate
        • Definition
          • Measures the frequency that someone who clicks on an ad makes a purchase, likes a site, or takes some other action desired by the advertiser. 
  • How do organizations develop an effective SMIS?
    • Steps
      • Define Your Goals
      • Identify  Success Metrics
        • Key Performance Indicators
          • Definition
            • Metrics that indicate you achieved goals.
        • Metrics
          • Definition
            • Measurements used to track performance
        • Vanity Metrics
          • Definition
            • Metrics that don't improve your decision making.
        • Success Metrics
          • Definition
            • Key performance indicators
      • Identify the Target Audience
        • Brand Awareness
          • Description
            • Extent that users recognize a brand
          • Metrics
            • Audience growth rates 
            • Brand mentions in Social Media
        • Conversion Rates
          • Description
            • Measures the frequency that someone takes a desired action.
          • Metrics
            • Click rate on SM content
            • Assisted social conversions
        • Web site traffic
          • Description
            • Quantity, frequency, duration, and depth of visits to a Web Site.
          • Metrics
            • Visitor frequency rate, referral traffic from SM.
        • User engagement
          • Description
            • Extent to which users interact with a site, application, or other media.
          • Metrics
            • Number of SM interactions
            • Reshares SM content
      • Define Your Value
        • Financial Capital
          • Definition
            • Money
        • Competitive Analysis
          • Definition
            • Identify the strengths and weaknesses in your competitors' use of social media.
  • What is an enterprise social network (ESN)?
    • Enterprise Social Network
      • Definition
        • Software platform that uses social media to facilitate cooperative work of people within an organization.
    • Enterprise 2.0
      • Web 2.0
        • Definition
          • Dynamic user-generated content systems
      • Enterprise 2.0
        • Definition
          • Use of emergent social software platforms within companies, or between companies and their partners or customers.
      • Folksonomy
        • Definition
          • Content structure that emerges from the processing of many user tags.
      • Enterprise 2.0 Components
        • SLATES
          • Search
            • Search for content
          • Links
            • Connects to resources
          • Authoring
            • Creating content
          • Tags
            • Definiton
              • Natural emmergence of content organization structure
            • Creation and Use of Folksonomy
          • Extensions
            • Measuring usage patterns of users to provide them with the content they desire, by predicting content of interest
          • Signals
            • Definition
              • When something of interest occurs in organizational content.
            • Publishing enterprising content to users based on subscriptions and alerts
    • Changing Communication
      • Communication Channels
        • Definition
          • Means of delivering messages
    • Deploying Successful Enterprise Social Networks
      • Best Practices
        • Definition
          • Methods that have been shown to produce successful results in prior implementations.
  • How can organization address SMIS security concerns?
    • Managing the Risk of Employee Communication
      • Social Media Policy
        • Definition
          • Statement that delineates employees' rights and responsibilities.
        • Pillars of Social Media Policy
          • Disclose
            • Definition
              • To be transparent and Open
          • Protect
            • Definition
              • To not overshare, slam competition, or tell secrets.
          • Use Common Sense
            • Definition
              • Add value 
              • Do not inflame or respond to all criticism
              • Admit Mistakes
    • Managing the Risk of Inappropriate Content
      • User Generated Content
        • Content on your social media site that is contributed to by users
        • Essence of SM relationships
      • Problems from External Sources
        • Junk and crackpot contributions
        • Inappropriate content
        • Unfavorable news
        • Mutinous movements
      • Responding to Social Networking Problems
        • Leave it
        • Respond to it
        • Delete it
  • 2025?
    • Social Media Unification
Chapter 9
  • How do Organizations use business intelligence (BI) Systems?
    • Business Intelligence Systems
      • Information systems that process operational, social, and other data to identify business intelligence for use by business professionals and other knowledge workers.
    • Business Intelligence
      • Definition
        • Patterns, relationships, trends, and predictions.
    • BI Application
      • Definition
        • Software component of a BI system
    • Decision Support Systems
      • Definition
        • Decision Making BI Systems
    • Uses of Business Intelligence
      • Project Management
      • Problem Solving
      • Deciding
      • Informing
    • What Are Typical BI Applications?
      • Identifying Changes in Purchasing Patterns
      • BI for Entertainment
      • Predictive Policing
        • Definition
          • Analyzing data of past crimes to predict where crimes are likely to occur next.
  • What are three primary activities in the BI process?
    • Data Acquisition
      • Definition
        • The Process of obtaining, cleaning, organizing, relating, and cataloging source data.
    • BI analysis
      • Definition
        • Process of creating business intelligence.
    • Primary Activities In The BI Process
      • Data Sources
      • Acquire Data
      • Perform Analysis
      • Publish Results
      • Receive feedback
      • Repeat
    • Publish Results
      • Definition
        • Delivering business intelligence to the knowledge workers who need it.
    • Push Publishing
      • Definition
        • Delivers business intelligence to users without any request from the users.
    • Pull Publishing
      • Definition
        • Requires the user to request BI results.
  • How do Organizations use data warehouses and data marts to acquire data?
    • Data Warehouse
      • Definition
        • Facility for managing an organization's BI data.
      • Functions of a Data Warehouse
        • Obtain Data
        • Cleanse Data
        • Organize and Relate Data
        • Catalog Data
    • Business Intelligence Users
      • Definition
        • Specialists in data analysis
    • Knowledge Workers
      • Definition
        • Nonspecialist users of BI
    • Granularity
      • Definition
        • Level of detail represented by the data
    • Data Mart
      • Definition
        • Data collection, smaller than the data warehouse, that addresses the needs of a particular department or functional area of the business.
  • How do Organizations use reporting applications?
    • Reporting application
      • Definition
        • BI application that inputs data from one or more sources and applies reporting operations to that data to produce BI.
      • Basic Reporting Operations
        • Sorting
        • Filtering
        • Grouping
        • Calculating
        • Formatting
    • RFM Analysis
      • Definition
        • Technique readily implemented with basic reporting operations, used to analyze and rank customers according to their purchasing patterns.
    • Online Analytical Processing
      • Definition
        • Provides the ability to sum, count, average, and perform other simply arithmetic operations on groups of data.
    • Measure
      • Definition
        • Data Item of Interest
    • Dimension
      • Definition
        • Characteristic of a measure
    • OLAP Cube
      • Definition
        • Shows the Measure and Dimension of Each Measure in an OLAP Report
    • Drill Down
      • Definition
        • Further divide the data into more detail.
  • How do Organizations use data mining applications?
    • Data Mining
      • Definition
        • Knowledge Discovery in Databases
    • Unsupervised Data Mining
      • Definition
        • Analysts do not create a model or hypothesis before running the analysis, they apply a data mining application to the data and observe the results.
    • Cluster Analysis
      • Definition
        • Statistical techniques identify groups of entities that have similar characteristics.
    • Supervised data mining
      • Definition
        • Data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.
    • Regression analysis
      • Definition
        • Measures the effect of a set of variables on another variable.
    • Neural Networks
      • Definition
        • Supervised data mining application used to predict values and make classifications.
    • Market Basket Analysis
      • Definition
        • An unsupervised data mining technique for determining sales patterns.
    • Cross Selling
      • Definition
        • Fact that customers who buy product "X" also buy product "Y", creates an opportunity for the products to be sold together. 
    • Support
      • Definition
        • Probability that two items will be purchased together
    • Confidence
      • Definition
        • Conditional probability estimate
    • Lift
      • Definition
        • Ratio of confidence to the base probability of buying an item.
    • Decision Tree
      • Definition
        • Hierarchical arrangement of criteria that predict a classification or a value.
  • How do Organizations use BigData applications?
    • Review of Big Data
      • Big Data data sets are at least a petabyte in size, but usually larger
      • Big Data is generated rapidly
      • Big Data has structured data, free-form text, log files, possibly graphics, audio, and video.
    • Map Reduce
      • Definition
        • Technique for harnessing the power of thousands of computers working in parallel.
    • Hadoop
      • Definition
        • Open source program supported by the Apache Foundation that implements MapReduce on potentially thousands of computers.
    • Pig
      • Definition
        • Query language included with Hadoop.
  • What is the role of knowledge management systems?
    • Knowledge Management
      • Definition
        • Process of creating value from intellectual capital and sharing that knowledge with employees, managers, suppliers, customers, and others who need that capital.
      • How Does Knowledge Management Benefit Organizations
        • Improve Process Quality
        • Increase Team Strength
    • Expert Systems
      • Definition
        • Rule Based Systems that encode human knowledge in the form of If/Then rules.
    • If/Then Rules
      • Definition
        • Statements that specify if a particular condition exists, and then to take some action.
    • Expert System Shells
      • Definition
        • Programs that process a set of rules
    • Content Management Systems
      • Definition
        • Information Systems that support the management and delivery of documents including reports, web pages, and other expressions of employee knowledge.
      • Common Alternatives for Content Management Applications
        • In-House Custom
        • Off The Shelf
        • Public Search Engine
    • Hyper Social Knowledge Management
      • Definition
        • Application of social media and related applications for the management and delivery of organizational knowledge resources.
    • Rich Directory
      • Definition
        • Employee Directory that includes not only the standard name, email, phone, and address but also organizational structure and expertise.
  • What are the alternatives for publishing BI?
    • Static Reports
      • Definition
        • BI documents that are fixed at the time of creation and do not change.
    • Dynamic Reports
      • Definition
        • BI Documents that are updated at the time they are requested.
    • BI Publishing Alternatives
      • Email or Collaboration Tool
        • Static Type
      • Web Server
        • Static/Dynamic Type
      • SharePoint
        • Static/Dynamic
      • BI Server
        • Dynamic
    • Subscriptions
      • Definition
        • User requests for particular BI results on a particular schedule or in response to particular events.
    • BI Server
      • Definition
        • Web Server Application that is purpose built for the publishing of business intelligence.
  • 2025?
    • The Singularity
      • Computer Systems Become Capable of Thinking on Their Own and Developing Their Own Software

Wednesday, July 20, 2016

IS Chapter 4, 5, 6, Notes

Chapter 4
  • What do Business Professionals Need To Know About Computer Hardware?
    • CPU
      • What is The CPU?
        • Central Processing Unit
          • The Brain of the Computer
      • How Does The CPU Work?
        • Works in Conjunction with Random Access Memory 
          • Reads data and instructions from memory
          • Stores results of computation in memory
      • How is CPU Speed Expressed?
        • Hertz
          • Definition
            • The Speed Cycles of CPUs
          • Speeds Based On Computers
            • Slow Personal Computers
              • 1.5 Gigahertz
            • Fast Dual Processor PC
              • 3+ Gigahertz
            • 32 Bit and 64 Bit CPUs
              • Needs a 64 Bit Processor, to use more than 4GB of Memory
    • Dual Processors vs Quad Processors 
      • Have varying CPU speed, function, and cost.
    • What Are Basic Types of Hardware?
      • Server Farms
        • Large Collection of Coordinated Servers
      • Tablets
      • Personal Computers
      • Servers
      • Smartphones
    • Binary
      • Definition
        • Programming based on telling the difference between two states.
      • Mechanical Methods for Binary
        • Reflection
        • Magnetic Polarization
        • Light Switches
  • How Can New Hardware Effect Competitive Strategies?
    • Client
      • What Do Clients Connect to, to receieve information?
        • Servers
      • Operating System
        • Programs that control the client computer resources.
      • Application Programs
        • Applications that are processed on Client's Computer.
    • Server
      • Operating System
        • Programs that control the server computer resources.
      • Application Programs
        • Applications that are processed on Server's Computer.
  • What Do Business Professionals Need To Know About Software?
    • Virtual Machines
      • A Server's Computational Power Remotely Accessed in A Software Application 
      • Granting the Illusion that someone has their computer.
    • Ownership Vs Licensing
      • License Software
        • Right to Use A Specified Number of Copies
        • It Limits a User's Liability
      • Site License
        • Costs a Flat Fee
        • Installs Software on all company computers or at a specific site
      • Open Source
        • No license fee
    • How Do Organizations Obtain Different Types of Applications?
      • Applications You Can Get Off The Shelf
        • Horizontal Applications
      • Applications You Can Get Off The Shelf And Then Customized
        • Horizontal Applications
        • Vertical Applications
      • Applications You Can Get Custom Developed
        • One of a Kind Applications
    • What is Firm Ware?
      • Software installed into read only memory, the program's logic is designed into device's circuitry 
  • Is Open Source Software A Viable Alternative?
    • Depends on the Situation's Restraints and Requirements
    • Free Open Source Software might require support and operational costs that are higher than normal licensing fees.
  • What Are The Differences Between Native And Web Applications?
    • Native Applications
      • High Skill Level
      • High Price
      • Sophisticated
      • Professional Programmers Only
      • Run on any operating system and device
      • Limited by the capability of browsers
    • Web Applications
      • Low to High Skill Level
      • Professional Programmers, Web Developers, and Business Professionals Can Use Them
      • Vary in Price
      • Vary in Sophistication
    • Thin-Client Applications
      • You get them via the web
      • Require Modern Browsers to Run
      • Cheaper to Develop
      • Cheaper to Maintain
      • May Lack Wow Factor
  • Why Are Mobile Systems Increasingly Important?
    • The World is Connected, People Can Do Things on The Go
  • What Are The Challenges of Personal Mobile Devices At Work?
    • Advantages
      • Cost Savings
      • Greater Employee Satisfaction
      • Reduced Need for Training
      • Higher Productivity
      • Reduced Support Costs
    • Disadvantages
      • Data Loss or Damage
      • Loss of Control
      • Compatibility Problems
      • Risk of Infection
      • Greater Support Costs
  • 2025?
    • New Jobs
    • Everything is Connected


Chapter 5
  • What is the Purpose of A Database?
    • To organize and keep track of things and to organize and keep track of themes.
    • Spreadsheets Vs Databases
      • Spreadsheets
        • Has only a single theme
        • Are not made to be able to pull data
        • Is good for serving one user
      • Databases
        • Have multiple themes
        • Are made to be able to pull data
        • Is good for serving multiple users
      • Form
        • An User Interface for the purpose of entering data.
  • What is a Database?
    • Relational Database
      • Made up of Tables
        • Tables are made up of rows and columns
          • Rows and columns have a relationship with one another.
      • Multiple Tables can be related with one another
    • Meta Data
      • Data about Data 
    • Tables or Files + Relationship Among Rows in Tables + Meta Data
  • What is a Database Management System?
    • Program, licensed by vendors, used to create, process, and administer a database. 
    • Operations
      • Read Data
      • Insert Data
      • Modify Data
      • Delete Data
    • SQL
      • Structured Query Language 
    • Administering the Database
      • Set up security system involving user accounts, passwords, permissions, and limits for processing.
      • Limit user permissions in very specific ways
      • Backs up data, adds structure, improves performance, and removes unwanted data. 
      • Summary of Database Administration Tasks
        • Operation
        • Backup
        • Recovery
        • Adaptation
        • Development
          • Create and Staff Database Administration Function
          • Form Steering Committee 
          • Specify Requirements
          • Validate Data Model
          • Evaluate Application Data
  • How do Database Applications Make Databases More Useful?
    • Forms
      • View Data
      • Insert Data
      • Update Data
      • Delete Existing Data
    • Queries
      • Search Based Upon User Provided Data Values
    • Reports 
      • Generates a structured presentation of the data
      • Uses Filters
    • Application Programs
      • Special operations
      • Security
      • Data Consistency
  • How are Data Models Used For Database Development?
    • Components of Entity Relationship Data Model
      • Entities
        • Something users want to track
      • Primary Key
        • Shorthand name of an Entity
      • Attributes
        • Describes entity characteristics
      • Identifiers
        • Uniquely identifies one entity instance from another instance of an entity.
    • Client Side Coding
      • Html5
      • Css3
      • JavaScript
    • Server Side Coding
      • C#
      • Java
      • Node.js Java Script
  • How is a Data Model Transformed Into A Database Design?
    • Normalization
      • Converts one badly structured table into two or more well structured tables.
    • Goal
      • Construct tables with data about a single theme or entity.
    • Purpose
      • To minimize data integrity problems
    • Data Integrity Problems
      • Produce incorrect and inconsistent information
        • Users loose confidence in information
          • Systems gains a poor reputation
      • Can only occur if data is replicated
    • Summary of Normalization
      • Represent Each Entity With A Table
        • Entity identifier becomes table key
        • Entity attributes become table columns
      • Normalize Tables Are Necessary
      • Represent Relationships
        • Use foreign keys
        • Add additional tables for N:M relationships
  • What is the User's Role In Development of Databases?
    • Users are the final judges
    • Users' review of data models is crucial
      • Ensure its accuracy reflects users' view of the business.
      • Entities must contain all of the data, you and your employees need to do your jobs, and relationships must accurately represent your view of the business.
    • User Mistakes will come back to haunt them.
  • 2025?
    • NOSQL DBMS is the Future

Additional Notes
  • Rule of Themes
    • For a Single Theme use a...
      • Spreadsheet
    • For Multiple Themes use a...
      • Database

Chapter 6


  • Why is the Cloud the Future of Most Organizations?
    • What Does Elastic Leasing Mean?
      • Flexible for Unpredictable Demand
      • Organizations only pay for the resources they actually use.
    • What is The Cloud?
      • Elastic Leasing of computer resources via the internet.
    • How do Organizations Pool Resources?
      • Many organizations share the same physical hardware through virtualization.
    • What is the Benefit Organizations Get From The Economies of Scale of Pooling Resources?
      • Average Cost of Production decreases as the size of the operation increases.
    • What are Web Farms?
      • Enormous data centers, run by major cloud vendors.
    • When Would You Not Want to Use The Cloud?
      • If the law or standard industry practice, require physical control or possession of data.
        • Example
          • Some financial institutions if not all, are required to have physical control over its data.
  • What network technology supports the cloud?
    • Types of Network Technology
      • Local Area Network
        • Characteristics
          • Computers connected at a single physical site.
        • Protocol
          • Bluetooth
            • For transmitting data short distances
      • Wired Area Network
        • Characteristics
          • Computers connected between two or more seperate sites.
      • Internet and internets
        • Characteristics
          • Network of networks
    • How are Communication Speeds Expressed?
      • Bits
    • How is Memory Size Expressed?
      • Bytes
        • One Byte Equals Eight Bits
    • Important ISP Functions
      • Provides legitimate internet access
      • Gateway to the internet
      • Collects money from customers who pay access fees and other charges to telecoms to pay for internet 
  • How does the cloud work?
    • What Are Packets?
      • Messages that are broken down and moved through the internet.
    • What Are Carriers?
      • Telecom Providers
    • What Are Peer Agreements?
      • Agreements to exchange traffic among multiple carriers, without paying access fees.
    • What is Net Neutrality?
      • All data is treated equally
    • What is the Bandwidth Problem?
      • Some people use more bandwidth than others
    • What is a Public IP Address?
      • Identifies a particular device on public internet
    • What is the ICANN?
      • Internet Corporation For Assigned Names And Numbers
    • Who assigns Public IP Addresses?
      • ICANN
    • What is a Private IP Address?
      • Identifies a device on a private network
        • Probably a LAN Network
    • What are the Major Benefits of IP Addresses?
      • IP addresses are conserved when multiple computers are on the same public LAN Network.
      • Using Private IP addresses eliminates registering for an IP address from ICANN.
    • What is IPv4?
      • Four Decimal Dotted Notation
        • Example
          • 123.123.123.123
    • What is a Domain Name?
      • Defininition
        • Unique name affiliated with a public IP address
      • Important Notes
        • Many domain names can point to the same address
        • Domain Names can change their affiliated IP addresses 
    • Three Tier Architecture 
      • User Tier
        • User Computers
          • Web Browsers
      • Server Tier
        • Web Server Computers
          • Web Server
          • Other Applications
          • Computer Server Applications
      • Instructions and Data
      • Database Tier
        • Database Management System
        • Database
    • What Are SOA Principles?
      • SOA 
        • Surface Oriented Architecture
      • Load Balancers
        • Help balance the loads of three tier architecture at each tier.
      • Each department formally states the data it expects to receive, with request and data it returns in response
      • Every Interaction is Done in The Same Way
      • No Department needs to know who works in other departments or how other departments work
    • Hierarchy of Protocols Supporting Web Services
      • Web Service Protocols
        • WSDL/SOAP
      • Application Layer Protocols
        • smtp
        • ftp
        • http(s)
      • Internet Plumbing Protocols
        • Four more layers or protocols
        • TCP/IP Protocol Architecture
  • How do organizations use the cloud?
    • Content Delivery Networks
      • System of hardware and software stores user data in multiple geographic locations, and makes data available on demand.
      • Benefits
        • Minimizes Latency
        • Protection From DOS Attacks
        • Reduced Delivery Costs For Mobile Users
        • Pay as you go
      • When They Are Best Used
        • Store and Deliver Seldom Used Content
  • How can AllRoad Parts use the cloud?
    • SASS Products
      • Definition
        • Software as a service
      • Use
        • To download stuff
      • Provide more added value
    • PaaS Services
      • Definition
        • Platform as a Service
      • Use
        • Virtualization
          • Virtual Machines
      • Provide more added value
    • IaaS Services
      • Definition
        • Infrastructure as a Service
      • Use
        • Machine with possible software already installed
      • Level of Service
        • Lowest
      • Provides basic hardware in the cloud
      • May acquire servers to load operating systems on them
      • Requires considerable expertise and management
      • Not available for small companies
  • How can organizations use cloud services securely?
    • VPN
      • Virtual Private Networks
    • Virtual Private Cloud
      • Subset of a public cloud with highly restricted, secure access. 
    • What is Geotagging?
      • Geographical metadata added to everything
  • 2025?
    • Faster, safer, better, cloud services

    Tuesday, July 19, 2016

    IS Access Lab In Class Notes


    • Microsoft Access 
      • Level of Data Base
        • Personal Data Base
      • Database File Extension for Access 2013
        • .accdb
      • How to Make A Table
        • Switch to Design View
        • Name Table
        • Label Each Row and Set Each Row Data Type As Short Text
          • If a row is specifically a number
            • Then set the data type as "number"
      • How Do You Make Multiple Rows Primary Keys?
        • Hold control and click each row
        • Click the primary key button
      • Why in the Example are Columns Underlined?
        • They are primary keys
      • How Do You Make Something Uniquely Identified
        • Highlight a row
        • Click the Primary Key Button
      • How Do You Create a Form For A Table
        • Highlight Table
        • Click "Form" Under the Create Tab
      • How Do You Create Relationships
        • Close all tables
        • Click Relationships Under Create Tab
        • Hold Control and Click all Tables That You Want to Relate
        • Click Add
        • Close Window
      • How To Create a Relationship Between Table Rows
        • Drag Rows of the same name into each other
        • A window will pop up, that is labeled Edit Relationships
        • Check mark 'Enforce Referential Integrity'
        • Click Create
      • How To Create A Query
        • Close all Tables
        • Goto Create Tab
        • Click Query Design
        • Hold Control and Select All Necessary Tables
        • Click Add
        • Close Window
        • Set Each Appropriate Field
        • Type the Appropriate Criteria under the Appropriate Field, To Grab Info only on that Criteria
    • Microsoft SQLServer 
      • Level of Database
        • Mid Range Database
    • Oracle, IBM DB 2 
      • Level of Database
        • Enterprise Strength Database System

    Persuasive Presentation is Due on August 2nd

    August 2nd

    Persuasive Presentation is Due

    Monday, July 18, 2016

    Information Systems Chapter 6


    • Why is the Cloud the Future of Most Organizations?
      • What Does Elastic Leasing Mean?
        • Flexible for Unpredictable Demand
        • Organizations only pay for the resources they actually use.
      • What is The Cloud?
        • Elastic Leasing of computer resources via the internet.
      • How do Organizations Pool Resources?
        • Many organizations share the same physical hardware through virtualization.
      • What is the Benefit Organizations Get From The Economies of Scale of Pooling Resources?
        • Average Cost of Production decreases as the size of the operation increases.
      • What are Web Farms?
        • Enormous data centers, run by major cloud vendors.
      • When Would You Not Want to Use The Cloud?
        • If the law or standard industry practice, require physical control or possession of data.
          • Example
            • Some financial institutions if not all, are required to have physical control over its data.
    • What network technology supports the cloud?
      • Types of Network Technology
        • Local Area Network
          • Characteristics
            • Computers connected at a single physical site.
          • Protocol
            • Bluetooth
              • For transmitting data short distances
        • Wired Area Network
          • Characteristics
            • Computers connected between two or more seperate sites.
        • Internet and internets
          • Characteristics
            • Network of networks
      • How are Communication Speeds Expressed?
        • Bits
      • How is Memory Size Expressed?
        • Bytes
          • One Byte Equals Eight Bits
      • Important ISP Functions
        • Provides legitimate internet access
        • Gateway to the internet
        • Collects money from customers who pay access fees and other charges to telecoms to pay for internet 
    • How does the cloud work?
      • What Are Packets?
        • Messages that are broken down and moved through the internet.
      • What Are Carriers?
        • Telecom Providers
      • What Are Peer Agreements?
        • Agreements to exchange traffic among multiple carriers, without paying access fees.
      • What is Net Neutrality?
        • All data is treated equally
      • What is the Bandwidth Problem?
        • Some people use more bandwidth than others
      • What is a Public IP Address?
        • Identifies a particular device on public internet
      • What is the ICANN?
        • Internet Corporation For Assigned Names And Numbers
      • Who assigns Public IP Addresses?
        • ICANN
      • What is a Private IP Address?
        • Identifies a device on a private network
          • Probably a LAN Network
      • What are the Major Benefits of IP Addresses?
        • IP addresses are conserved when multiple computers are on the same public LAN Network.
        • Using Private IP addresses eliminates registering for an IP address from ICANN.
      • What is IPv4?
        • Four Decimal Dotted Notation
          • Example
            • 123.123.123.123
      • What is a Domain Name?
        • Defininition
          • Unique name affiliated with a public IP address
        • Important Notes
          • Many domain names can point to the same address
          • Domain Names can change their affiliated IP addresses 
      • Three Tier Architecture 
        • User Tier
          • User Computers
            • Web Browsers
        • Server Tier
          • Web Server Computers
            • Web Server
            • Other Applications
            • Computer Server Applications
        • Instructions and Data
        • Database Tier
          • Database Management System
          • Database
      • What Are SOA Principles?
        • SOA 
          • Surface Oriented Architecture
        • Load Balancers
          • Help balance the loads of three tier architecture at each tier.
        • Each department formally states the data it expects to receive, with request and data it returns in response
        • Every Interaction is Done in The Same Way
        • No Department needs to know who works in other departments or how other departments work
      • Hierarchy of Protocols Supporting Web Services
        • Web Service Protocols
          • WSDL/SOAP
        • Application Layer Protocols
          • smtp
          • ftp
          • http(s)
        • Internet Plumbing Protocols
          • Four more layers or protocols
          • TCP/IP Protocol Architecture
    • How do organizations use the cloud?
      • Content Delivery Networks
        • System of hardware and software stores user data in multiple geographic locations, and makes data available on demand.
        • Benefits
          • Minimizes Latency
          • Protection From DOS Attacks
          • Reduced Delivery Costs For Mobile Users
          • Pay as you go
        • When They Are Best Used
          • Store and Deliver Seldom Used Content
    • How can AllRoad Parts use the cloud?
      • SASS Products
        • Definition
          • Software as a service
        • Use
          • To download stuff
        • Provide more added value
      • PaaS Services
        • Definition
          • Platform as a Service
        • Use
          • Virtualization
            • Virtual Machines
        • Provide more added value
      • IaaS Services
        • Definition
          • Infrastructure as a Service
        • Use
          • Machine with possible software already installed
        • Level of Service
          • Lowest
        • Provides basic hardware in the cloud
        • May acquire servers to load operating systems on them
        • Requires considerable expertise and management
        • Not available for small companies
    • How can organizations use cloud services securely?
      • VPN
        • Virtual Private Networks
      • Virtual Private Cloud
        • Subset of a public cloud with highly restricted, secure access. 
      • What is Geotagging?
        • Geographical metadata added to everything
    • 2025?
      • Faster, safer, better, cloud services