Term
|
Definition
| Database designers assign the .... to fields that contains numbers with decimal places---prices, percentages, etc |
|
|
Term
|
Definition
| The ..... is used to store dates in a format that allows them to be manipulated |
|
|
Term
Logical Data Type
(Boolean or yes/no data type) |
|
Definition
| The .....is used for true/false or yes/no data using minimal storage space |
|
|
Term
|
Definition
| A .... is a calculation that a DBMS performs during processing, and then temporarily stores in a memory location |
|
|
Term
Entity- Relationship Diagram
(ER Diagram or ERD) |
|
Definition
| The relationship between record types can be depicted graphically with a ...... |
|
|
Term
|
Definition
| A ..... is a specification that the database designer helps set up to filter data entered into a particular field |
|
|
Term
|
Definition
| When one record is related to many records, the relationship is referred to as a .... |
|
|
Term
|
Definition
| A .... is a field that contains data unique to a record |
|
|
Term
|
Definition
| A table's .... is the order in which records are stored on disk |
|
|
Term
|
Definition
| A record that contains data is referred to as a ...., or simply a record |
|
|
Term
|
Definition
| A ...., sometimes referred to as a multidimensional database, organizes relationships over three or more dimensions |
|
|
Term
|
Definition
| A ... is a collection of data |
|
|
Term
|
Definition
| .... refers to the arrangement of fields, tables, and relationships in a database |
|
|
Term
|
Definition
| A filing cabinet full of folders and papers would be classified as an .... because every document has a unique structure and contains different kinds of data |
|
|
Term
| Object-Relational Databse |
|
Definition
| The term .... is used to describe a variety of technologies that combine object-oriented and relational concepts |
|
|
Term
|
Definition
| A ... uses a uniform format to store data for each person or thing in the file |
|
|
Term
Object Database
(object oriented database) |
|
Definition
| An .....stores data as objects, which can be grouped in to classes and defined by attributes and methods |
|
|
Term
|
Definition
| In database jargon, a .... is an association between data that's stored in different record types |
|
|
Term
|
Definition
| A process called .... helps database designers create a database structure that can save storage space and increase processing efficiency |
|
|
Term
|
Definition
| A table's ... is one or more fields used to specify where new records are inserted in a table |
|
|
Term
|
Definition
| A ... stores data in a collection of related tables |
|
|
Term
|
Definition
| A ... validates an entry by checking data in a file or database table |
|
|
Term
|
Definition
| A ... uses a mesh-like structure to offer the additional capacity to define many-to-many relationships |
|
|
Term
|
Definition
| .... refers to a branch of data mining that focuses on predicting future probabilities and trends |
|
|
Term
|
Definition
| A .... usually provides a variable-length field into which users can enter comments |
|
|
Term
|
Definition
| A ... is a template that adds the correct formatting as data is entered |
|
|
Term
|
Definition
| A .... contains the outline or general specifications for a report , including such elements as the report title, field to include, fields to subtotal or total, and report format specifications |
|
|
Term
|
Definition
| A field has a unique .... that describes the contents |
|
|
Term
|
Definition
| A ... specifies the way data is represented on the disk and in RAM |
|
|
Term
|
Definition
| A .... is a repository for data from more than one database |
|
|
Term
|
Definition
| The template for a record is referred to as a ..... |
|
|
Term
|
Definition
| The .... stores URLs used to link directly from a database to a Web page |
|
|
Term
|
Definition
| A .... contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key |
|
|
Term
|
Definition
| .... is typically assigned to fixed-length fields that hold character data--people's names, album titles, etc |
|
|
Term
|
Definition
| In a ...., uppercase letters are not equivalent to their lower case counterparts |
|
|
Term
|
Definition
| A .... is a sequence of records, similar to a file |
|
|
Term
|
Definition
| A .... is like an accordion- it expands to fit the data you enter, up to some maximum number of characters |
|
|
Term
| Executive Dashboard Software |
|
Definition
| To analyze and mine complex data sets, decision makers sometimes use ....., which provides tools for formulating OLAP queries and displaying results visually |
|
|
Term
|
Definition
| A ... contains the smallest unit of meaningful information, so you might call it the basic building block for a structured file or database |
|
|
Term
|
Definition
| A ... means that a record in one record type is related to only one in another record type |
|
|
Term
|
Definition
| A .... allows one-to-one and one-to-many relationships, linked in a hierarchal structure |
|
|
Term
|
Definition
| .... is the amount of data that is repeated or duplicated in a database |
|
|
Term
|
Definition
| The ... is used for fields that contain whole numbers-- quantities, repetitions, rankings, etc |
|
|
Term
|
Definition
| ... refers to the process of analyzing existing database information to discover previously unknown and potentially useful information, including relationships and patterns |
|
|
Term
|
Definition
| .... refers to the number of associations that can exist between two record types |
|
|
Term
BLOB
(binary large object) |
|
Definition
| A ..... is a collection of binary data stored in a single field of a database |
|
|
Term
|
Definition
| the underlying structure of a database is referred to as a ..... |
|
|
Term
|
Definition
| One of today's most advances data analysis methods, ....allows decision makers to look for relationships between multiple data dimensions |
|
|
Term
|
Definition
| The simplest model for storing data is a ..... that consists of a single, two-dimensional table of data elements |
|
|
