Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/15

Click to flip

15 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
Business Intelligence
knowledge about your customers, competitors, business partners, environment, and internal operations
becci
OLTP
gathering and processing transaction information and updating existing information to reflect transaction
- Used for day-to-day activities
- Info stored in databases
OLA
Manipulation of information to support decision making
- Support decision making
- Summary info
Databases
- Collections of information
- Created with logical structures
- With logical ties within the information
- With built-in integrity constraints
Data Dictinary
contains the logical structure of the information in a database; documentation of database components
Primary Key
field that uniquely identifies each record in a table.
Foreign Key
Primary key in a related table used to link two tables
Integrity constraint
rule that helps ensure the quality of information; reliability; errors? all infor there?
DBMS
helps you specify the logical organization for a database and access and use the information within a database
DBMS Tools
1)DBMS Engine
2)Data Definition Subsystem
3)Data Manipulation Subsystem
4)Application Generation Subsytem
5)Data Administration Subsystem
EDMAA
DBMS Engine
accepts logical requests, converts them into their physical equivalent, and access the database and data dictionary
DBMS Engine Physical view
how information is arranged, stored, and accessed on a storage device.
DBMS Engineligical view
how you (knowledge worker) need to arrange and access information
Data definition subsytem
helps you create and maintain the data dictonary and define the structure of the files in a database
Data Manipulation Subsytem
helps you add, change, and delete information
- views
- reports
- QBE tools
- SQL