Mis Chapter 3 Database Lecture Exam Two

Front 1

Database

Back 1

Group of related files

Front 2

Entity

Back 2

Person, place, thing, or event about which information must be kept

Front 3

Attribute

Back 3

A piece of information describing a particular entity

Front 4

Key field

Back 4

Field that uniquely identifies every record in a file

Front 5

Database Terms

Back 5

FILE = TABLE = RELATION = ENTITY

Front 6

COLUMN

Back 6

COLUMN:
FIELD = ITEM = ELEMENT = ATTRIBUTE

see slide 3-6

Front 7

ROW

Back 7

ROW:
RECORD = TUPLE = INSTANCE

see slide 3-7

Front 8

BLOCK:

Back 8

BLOCK:
VALUE

see slide 3-8

Front 9

Primary Key

Back 9

Element
Item
Attribute
Field

Front 10

Examples of Keys

Back 10

Students – ID Number
Vehicles – VIN or Vehicle Identification Number
Airplane – Tail Number
Book - ISBN

Front 11

Examples of Concatenated Keys

Back 11

Airline Flight
Oil well in Oklahoma
Class at OU

Front 12

Database Associations

Back 12

One-to-one (teams to stadiums)
One-to-many (player to team)
Many-to-many (players to games)

Front 13

Why Study Data Resource Management?

Back 13

Today’s business enterprises cannot survive or succeed without quality data about their internal operations and external environment.

Front 14

Data Resource Management

Back 14

Definition:
A managerial activity that applies information systems technologies to the task of managing an organization’s data resources to meet the information needs of their business stakeholders

Front 15

Database Technology

Back 15

A collection of related data organized in a way that makes it valuable and useful
Allows organizations to retrieve, store, and analyze information easily
Is vital to an organization’s success in running operations and making decisions

Front 16

Entities

Back 16

Things we store information about. (i.e. persons, places, objects, events, etc.)
Have relationships to other entities (i.e. the entity Student has a relationship to the entity Grades in a University Student database

Front 17

Attributes

Back 17

These are pieces of information about an entity (i.e. Student ID, Name, etc. for the entity Student)

Front 18

Field

Back 18

Individual characteristics about an ENTITY. Fields are also called attributes or columns depending on the type of DBMS

Front 19

Record

Back 19

A group of fields or attributes to describe a single instance of an ENTITY. These are also called rows depending on the DBMS

Front 20

File

Back 20

A collection of records or instances for a given ENTITY. These are also called tables depending on the DBMS

Front 21

Database

Back 21

A collection of files or entities containing information to support a given system or a particular topic area

Front 22

Levels of a Database Management System (DBMS)

Back 22

Field (HIGHEST)
Record
File
Database (LOWEST)

Front 23

File Processing Approach (Old School)

Back 23

Storage Media: Sequential tapes or files
Data: stored in long sequential files
Organization: redundant data in multiple files
Efficiency: data embedded to support processing
Updates: requires multiple updates in many files
Processing: slower query/faster processing

Front 24

Data Base Approach (New School-TODAY)

Back 24

Storage Media: Direct Access Storage Device (DASD)
Data: stored in related tables
Organization: redundant data minimized/eliminated
Efficiency: data only stored only in tables
Updates: requires few or one update for a data field
Processing: faster query/slower processing

Front 25

Storage Media

File Processing Approach (Old School)

Back 25

Sequential tapes or files

Front 26

Data

File Processing Approach (Old School)

Back 26

stored in long sequential files

Front 27

Organization

File Processing Approach (Old School)

Back 27

redundant data in multiple files

Front 28

Efficiency

File Processing Approach (Old School)

Back 28

data embedded to support processing

Front 29

Updates

File Processing Approach (Old School)

Back 29

requires multiple updates in many files

Front 30

Processing

File Processing Approach (Old School)

Back 30

slower query/faster processing

Front 31

Storage Media

Data Base Approach (New School-TODAY)

Back 31

Direct Access Storage Device (DASD)

Front 32

Data

Data Base Approach (New School-TODAY)

Back 32

stored in related tables

Front 33

Organization

Data Base Approach (New School-TODAY)

Back 33

redundant data minimized/eliminated

Front 34

Efficiency

Data Base Approach (New School-TODAY)

Back 34

data only stored only in tables

Front 35

Updates

Data Base Approach (New School-TODAY)

Back 35

requires few or one update for a data field

Front 36

Processing

Data Base Approach (New School-TODAY)

Back 36

faster query/slower processing

Front 37

Database Administrator (DBA)

Back 37

Designs, develops and monitors performance of databases
Enforces policy and standards for data uses and security

Front 38

Systems Analyst

Back 38

Defines data requirements working with a DBA
Incorporates the database design into new program designs

Front 39

Systems Programmer

Back 39

Creates business applications that connect to databases
Tests the new systems and databases before use

Front 40

Database Systems Activities – Data Entry

Back 40

Example
Data is entered from paper employment applications into a form entry screen
The entry forms are designed to match the paper forms for easy entry
The form data is processed by the entry program and then stored in the employment database

see slide 3-23

Front 41

Query
Database Systems Activities – Query
see example - slide 3-24

Back 41

A database function that extracts and displays information from a database given selection parameters.

Front 42

SQL (Structure Query Language)
Database Systems Activities – Query
see example - slide 3-24

Back 42

A language to select and extract data from a database
The industry standard language for relational databases

Front 43

QBE (Query by Example)
Database Systems Activities – Query
see example - slide 3-24

Back 43

A technique that allows a user to design a query on a screen by dragging and placing the query field in their desired locations

Front 44

Report

Database Systems Activities – Report
see example - slide 3-25

Back 44

A database function that extracts and formats information from a database for printing and presentation

Front 45

Report Generator

Database Systems Activities – Report
see example - slide 3-25

Back 45

A specialized program that uses SQL to retrieve and manipulate data (aggregate, transform, or group)
Reports are designed using standard templates or can be custom generated to meet informational needs

Front 46

Data Model
3-26

Back 46

A map or diagram that represents entities and their relationships
Used by Database Administrators to design tables with their corresponding associations

Front 47

Database Keys

Back 47

Mechanisms used to identify, select, and maintain one or more records using an application program, query, or report

Front 48

Primary Key

Back 48

A unique attribute type used to identify a single instance of an entity.

Front 49

Compound Primary Key

Back 49

A unique combination of attributes types used to identify a single instance of an entity

Front 50

Secondary Key

Back 50

An attribute that can be used to identify one or more records within a table with a given value

Front 51

Designing Databases - Associations

Back 51

Associations
Define the relationships one entity has to another
Determine necessary key structures to access data
Come in three relationship types:
- One-to-One
- One-to-Many
- Many-to-Many

Front 52

Foreign Key

Back 52

An attribute that appears as a non-primary key in one entity (table) and as a primary key attribute in another entity (table)

Front 53

Entity Relationship Diagram (ERD)

see example - slide 3-30 & see 3-31

Back 53

Diagramming tool used to express entity relationships
Very useful in developing complex databases

Front 54

The Relational Model

Back 54

The most common type of database model used today in organizations
Is a three-dimensional model compared to the traditional two-dimensional database models
Rows (first-dimension)
Columns (second-dimension)
Relationships (third-dimension)
The third-dimension makes this model so powerful because any row of data can be related to any other row or rows of data

Front 55

Normalization

Back 55

A technique to make complex databases more efficient by eliminating as much redundant data as possible
Example: Database with redundant data (see slide 3-35)

Front 56

Data Dictionary

Back 56

Is a document that database designers prepare to help individuals enter data
Provides several pieces of information about each attribute in the database including:
Name
Key (is it a key or part of a key)
Data Type (date, alpha-numeric, numeric, etc.)
Valid Value (the format or numbers allowed)
Can be used to enforce Business Rules which are captured by the database designer to prevent illegal or illogical values from entering the database. (e.g. who has authority to enter certain kinds of data)

Front 57

Online Transactional Processing

Back 57

The mechanism by which customers, suppliers, and employees process business transactions for an organization
These users conduct transactions online through internal systems and external Websites for processing and storage

Front 58

Online Analytical Processing (OLAP)

Back 58

Graphical software tools that provide complex analysis of data stored on a database
OLAP tools enable users to analyze different dimensions of data beyond data summary and data aggregations of normal database queries
The OLAP Server is the chief component of an OLAP system which understands how the data is organized and has special functions for analyzing data
OLAP can provide time series and trend analysis views of data, data-drill downs, and the ability to answer “what-if” and “why” questions as part of its functions

Front 59

Data Mining

Back 59

Data Mining
Is a method companies use to analyze information to better understand their customers, products, markets, or any other phase of their business for which they have data
With data mining tools you can graphically drill down, sort or extract data based on certain conditions, perform a variety of statistical analysis
Data mining applications are very powerful and use highly complex algorithms to analyze and to identify opportunities

Front 60

Knowledge Management

Back 60

The process an organization uses to gain the greatest value from its knowledge assets

Front 61

Knowledge Assets

Back 61

All underlying skills routines, practices, principles, formulas, methods, heuristics, and intuitions whether explicit or tacit

Front 62

Explicit Knowledge

Back 62

Anything that can be documented, archived, or codified often with the help of information systems

Front 63

Tacit Knowledge

Back 63

The processes and procedures on how to effectively perform a particular task stored in a persons mind

Front 64

Best Practices

Knowledge Management System (KMS)

Back 64

Procedures and processes that are widely accepted as being among the most effective and/or efficient

Front 65

Technology

Knowledge Management System (KMS)

Back 65

Generally not a single technology but instead a collection of tools that include communication technologies (e.g. e-mail, groupware, instant messaging), and information storage and retrieval systems (e.g. database management system) to meet the Primary Objective

Front 66

Primary Objective


Knowledge Management System (KMS)

Back 66

How to recognize, generate, store, share, manage this tacit knowledge (Best Practices) for deployment and use