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

Click to flip

58 Cards in this Set

  • Front
  • Back
Query
a question you ask about the data stored in a database
DBMS
Database Management System - is a collection of programs that manages the database structure and controls access to the data stored in the database
Field
a single characteristic or attribute of a person, place, object, event, or idea
File
a collection of data that has a name and is stored in a computer; also called a document
Record
a complete set of field values for a specific person, place, object, event, or idea; also known as a row
database management
is a discipline that focuses on the proper generation, storage and retrieval of data
Data
raw facts
Information
is the result of processing raw data to reveal it's meaning
Knowledge
the body of information and facts about a specific subject
Metadata
data about data; through which the end-user data are integrated and managed
Data Inconsistency
exists when different versions of the same data appear in different places
Ad Hoc Query
is a spur of the moment question
_ is the body of information and facts about a specific subject
knowledge
_ is used to reveal the meaning of data
information
_ provides a description of the data characteristics and the set of relationships that link the data found within the database
metadata
a _ database supports a small number of users, or a specific department within an organization
workgroup
a _ database supports data distributed across several different sites
distributed
a desktop database is a _ database
single-user
most decision-support data are based on historical data obtained from _
operational databases
_ data are the result of formatting to facilitate storage, use and generation of information
structured
most data you encounter is best classified as _ data
semi-structured
a spreadsheet is an example of structured data
true
The organization of the data within the folders in a manual file system was determined by
its expected use
a _ is a collection of related records
file
the term _ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment
database system
class is a basic building block of all data models
true
a _ is anything about data which is to be collected and stored
entity
an _ is the equivalent of a field in a file system
attribute
a _ is bidirectional
relationship
a _ is a restriction placed on the data
constraint
_ are important to ensure data integrity
constraints
students and classes have a _ to _ relationship
many to many
a noun in a business rule translates to an _ in the data model
entity
a verb associating two nouns in a business rule translates to a _ in the data model
relationship
VMS/VSAM is an example of a
file system data model
Oracle 10g is an example of an
XML data model
MySQL is an example of a
relational data model
in the _ model, the basic logical structure is represented as an upside-down tree
hierarchical
one of the limitations of the _ model was that there were no implementation standards
hierarchical
in the _ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent
network
the _ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text
object-oriented
the _ model uses the term connectivity to label the relationship types
entity relationship
the _ model is said to be a semantic data model
object-oriented
data attributes contain calendar dates stored in a special format known as the _ data format
julian
_ data can have only a true or false (yes/no) condition
logical
no data entry at all is known as a _
null
referential _ means that if the foreign key contains a value, that value refers to an existing valid tuple in another relation
integrity
a _ key is defined as a key that is used strictly for data retrieval purposes
secondary
a _ key is a minimal (irreducible) superkey
candidate
the _ constraint can be placed on a column to ensure that every row in the table has a value for that column
NOT NULL
_ yields only the rows that appear in both tables
INTERSECT
_ yields a vertical subset of a table
PROJECT
a _ join links tables by selecting only the rows with common values in their common attributes
natural
in an outer join, the matched pairs would be retained, and any unmatched values in the other table would be left _
null
the _ is actually a system-created database whose tables store the user/designer-created database characteristics and contents
system catalog
in a database context, a _ indicates the use of different names to describe the same attribute
synonym
_ relational type is the "relational ideal"
1:M
since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes - as foreign keys- at least the _ keys of the tables that are to be linked
primary