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

Click to flip

18 Cards in this Set

  • Front
  • Back

What is the most common classification applied to a DBMS

expected type and extent of use

Wider access to well-managed data promotes an ________ view of the organizations operations and a clearer view of the big picture.

integrated

A _____ focuses primarily on storing data used to generate tactical or strategic decisions.

Data Warehouse

_____ are the people who use applications programs to run the organization's daily operations

End Users

All fields for a specific entity can be grouped together as a ______.

Record

Data processing specialists are in existence because of ______.

the need to track data and produce reports

A _______ allows the user to specify what must be done without specifying how it must be done.

procedural language

The basic building blocks of all data models are entities, attributes, relationships, and ______.

Constraints

The hierarchical database model depicts a set of _____ relationships.

one-to-many

A _______ is the equivalent of a file system's record type.

segment

The network database models have ______.

an owner/member relationship that promotes database integrity

The most widely used conceptual model is the _______ model.

ER

What model requires the most detail in its internal model?

Network

THe key's role is based on a concept known as ________.

determination

A superkey is any key that uniquely identifies each ________.

row

Within a table, the primary key must be unique so that it will identify each row. When this is the case, the table is said to exhibit ________ integrity.

Entity

A ________ key is defined as a key that is used strictly for data retrieval purposes.

secondary

A superkey that does not contain a subset of attributes that is itself a superkey is called a ___________.

Candidate key