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/24

Click to flip

24 Cards in this Set

  • Front
  • Back
The units of data ordered from smallest to largest are
attribute, record, table, database
In a database design, the concept of "entity" is implemented most directly as a:
table
An attribute that uniquely identifies a record is which type of key?
Primary (Primary key: A field included in a database that assures that each instance of an entity is stored or retrieved accurately.)
The most common language used to interface with databases is
SQL.
A text-based language used to query and manipulate the contents of a relational database is:
SQL.
The administrator responsible for a firm's database resources is known by this acronym.
DBA (Chief information officer; the IT manager )
A data query system that is based on a graphical interface is:
QBE (Text-based system )Query by example (QBE): A capability of a DBMS that enables data to be requested by providing a sample or a description of the types of data we would like to see.
In conceptual data modeling, the database is viewed as a collection of entities and their:
relationships.
The process of making a complex database simpler, more efficient, and stable is:
normalization.
The process of examining a database to uncover hidden relationships is data:
mining.
Graphical software tools that provide complex analysis of data stored in a database are called:
OLAP. (OLAP server: The chief component of an OLAP system that understands how data is organized in the database and has special functions for analyzing the data.)
The process of providing an immediate automated response to the requests of users is:
OLTP. (OLTP: Online transaction processing )
The units of data ordered from smallest to largest are
attribute, record, table, database
In a database design, the concept of "entity" is implemented most directly as a:
table. Table: A collection of related records where each row is a record and each column is an attribute.
An attribute that uniquely identifies a record is which type of key?
Primary (Primary key: A field included in a database that assures that each instance of an entity is stored or retrieved accurately.)
The most common language used to interface with databases is
SQL.
A text-based language used to query and manipulate the contents of a relational database is:
SQL.
The administrator responsible for a firm's database resources is known by this acronym.
DBA (Database administrator: A person responsible for the development and management of the organization's databases.- Chief information officer; the IT manager )
A data query system that is based on a graphical interface is:
QBE (Text-based system )(Query by example (QBE): A capability of a DBMS that enables data to be requested by providing a sample or a description of the types of data we would like to see.)
In conceptual data modeling, the database is viewed as a collection of entities and their:
relationships.
The process of making a complex database simpler, more efficient, and stable is:
normalization.
The process of examining a database to uncover hidden relationships is data:
mining.
Graphical software tools that provide complex analysis of data stored in a database are called:
OLAP. (OLAP server: The chief component of an OLAP system that understands how data is organized in the database and has special functions for analyzing the data.)
The process of providing an immediate automated response to the requests of users is:
OLTP. (OLTP: Online transaction processing -Immediate automated responses to the requests from multiple concurrent transactions from customers. )