Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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
|