Intro to IT- Management Chapter 5
Intro to IT- Management Chapter 5 Bus Adm 230
Popular in Intro to Info Technology Management
Popular in Business
This 3 page Class Notes was uploaded by Bailee Gustafson on Sunday March 20, 2016. The Class Notes belongs to Bus Adm 230 at University of Wisconsin - Milwaukee taught by George S. Nezlek, PhD in Spring 2016. Since its upload, it has received 13 views. For similar materials see Intro to Info Technology Management in Business at University of Wisconsin - Milwaukee.
Reviews for Intro to IT- Management Chapter 5
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 03/20/16
Chapter 5: Database Systems and Applications Database: o Organized collection of data Database Management System (DBMS): o Manipulates the database and provides an interface between the database and its users and other application programs Field: o A name, number, or combination of characters that describes an aspect of a business object or activity Record: o Collection of related data fields File: o Collection of related records Hierarchy of Data: o Bits, bytes, fields, records, files and databases Entity: o Person, place or thing for which data are collected, stored and manipulated Attribute: o Characteristic of an entity Data Item: o Specific value of an attribute Primary Key: o Field or set of fields that uniquely identifies the record Data Model: o Diagram of entities and their relationships Enterprise Data Modeling: o Data modeling done at the level of the entire enterprise Entity-Relationship (ER) Diagrams: o Data model that use basic graphical symbols to show the organization of relationships between data Relational Model: o Simple but highly useful way to organize data into collections of two-dimensional tables called relations Domain: o Range of allowable values for a data attribute Selecting: o Eliminating rows according to certain criteria Projecting: o Eliminating columns in a table Joining: o Combining two or more tables Linking: o Combining two or more tables through common data attributes to form a new table with only the unique data attributes SQL: o Special-purpose programing language for accessing and manipulating data stored in a relational database Visual Database: o Stores images of charge slips, X-rays and vital records Spatial Database: o Provides location-based services Schema: o Description of entire database Data Definition Language (DDL): o Collection of instructions and commands used to define and describe data and relationships in a specific database Data Dictionary: o Detailed description of all data used in database Data Manipulation Language (DML): o Specific language provided with a DBMS Database Administration (DBA): o Skilled and trained IS professional Data Administrator: o Nontechnical position responsible for defining and complementing consistent principles for a variety or data issues Data Warehouse: o Large database that collects business information from many sources in the enterprise in support of management decision making Data Mart: o Subset of a data warehouse that is used by small and medium sized businesses and departments within large companies to support decision making Key Performance Indicator (KPI): o Quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization Dashboard: o Data visualization tool that displays current status of the KPIs for an organization