Database 1

Front 1

Query

Back 1

a question you ask about the data stored in a database

Front 2

DBMS

Back 2

Database Management System - is a collection of programs that manages the database structure and controls access to the data stored in the database

Front 3

Field

Back 3

a single characteristic or attribute of a person, place, object, event, or idea

Front 4

File

Back 4

a collection of data that has a name and is stored in a computer; also called a document

Front 5

Record

Back 5

a complete set of field values for a specific person, place, object, event, or idea; also known as a row

Front 6

database management

Back 6

is a discipline that focuses on the proper generation, storage and retrieval of data

Front 7

Data

Back 7

raw facts

Front 8

Information

Back 8

is the result of processing raw data to reveal it's meaning

Front 9

Knowledge

Back 9

the body of information and facts about a specific subject

Front 10

Metadata

Back 10

data about data; through which the end-user data are integrated and managed

Front 11

Data Inconsistency

Back 11

exists when different versions of the same data appear in different places

Front 12

Ad Hoc Query

Back 12

is a spur of the moment question

Front 13

_ is the body of information and facts about a specific subject

Back 13

knowledge

Front 14

_ is used to reveal the meaning of data

Back 14

information

Front 15

_ provides a description of the data characteristics and the set of relationships that link the data found within the database

Back 15

metadata

Front 16

a _ database supports a small number of users, or a specific department within an organization

Back 16

workgroup

Front 17

a _ database supports data distributed across several different sites

Back 17

distributed

Front 18

a desktop database is a _ database

Back 18

single-user

Front 19

most decision-support data are based on historical data obtained from _

Back 19

operational databases

Front 20

_ data are the result of formatting to facilitate storage, use and generation of information

Back 20

structured

Front 21

most data you encounter is best classified as _ data

Back 21

semi-structured

Front 22

a spreadsheet is an example of structured data

Back 22

true

Front 23

The organization of the data within the folders in a manual file system was determined by

Back 23

its expected use

Front 24

a _ is a collection of related records

Back 24

file

Front 25

the term _ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment

Back 25

database system

Front 26

class is a basic building block of all data models

Back 26

true

Front 27

a _ is anything about data which is to be collected and stored

Back 27

entity

Front 28

an _ is the equivalent of a field in a file system

Back 28

attribute

Front 29

a _ is bidirectional

Back 29

relationship

Front 30

a _ is a restriction placed on the data

Back 30

constraint

Front 31

_ are important to ensure data integrity

Back 31

constraints

Front 32

students and classes have a _ to _ relationship

Back 32

many to many

Front 33

a noun in a business rule translates to an _ in the data model

Back 33

entity

Front 34

a verb associating two nouns in a business rule translates to a _ in the data model

Back 34

relationship

Front 35

VMS/VSAM is an example of a

Back 35

file system data model

Front 36

Oracle 10g is an example of an

Back 36

XML data model

Front 37

MySQL is an example of a

Back 37

relational data model

Front 38

in the _ model, the basic logical structure is represented as an upside-down tree

Back 38

hierarchical

Front 39

one of the limitations of the _ model was that there were no implementation standards

Back 39

hierarchical

Front 40

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

Back 40

network

Front 41

the _ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text

Back 41

object-oriented

Front 42

the _ model uses the term connectivity to label the relationship types

Back 42

entity relationship

Front 43

the _ model is said to be a semantic data model

Back 43

object-oriented

Front 44

data attributes contain calendar dates stored in a special format known as the _ data format

Back 44

julian

Front 45

_ data can have only a true or false (yes/no) condition

Back 45

logical

Front 46

no data entry at all is known as a _

Back 46

null

Front 47

referential _ means that if the foreign key contains a value, that value refers to an existing valid tuple in another relation

Back 47

integrity

Front 48

a _ key is defined as a key that is used strictly for data retrieval purposes

Back 48

secondary

Front 49

a _ key is a minimal (irreducible) superkey

Back 49

candidate

Front 50

the _ constraint can be placed on a column to ensure that every row in the table has a value for that column

Back 50

NOT NULL

Front 51

_ yields only the rows that appear in both tables

Back 51

INTERSECT

Front 52

_ yields a vertical subset of a table

Back 52

PROJECT

Front 53

a _ join links tables by selecting only the rows with common values in their common attributes

Back 53

natural

Front 54

in an outer join, the matched pairs would be retained, and any unmatched values in the other table would be left _

Back 54

null

Front 55

the _ is actually a system-created database whose tables store the user/designer-created database characteristics and contents

Back 55

system catalog

Front 56

in a database context, a _ indicates the use of different names to describe the same attribute

Back 56

synonym

Front 57

_ relational type is the "relational ideal"

Back 57

1:M

Front 58

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

Back 58

primary