Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database > study guide > Flashcards

study guide Flashcards

1
Q

ad hoc query

A

A “spur-of-the-moment” question.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

centralized database

A

A database located at a single site.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

data

A

Raw facts, that is, facts that have not yet been processed to reveal their
meaning to the end user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

data anomaly

A

A data abnormality that exists when inconsistent changes to a
database have been made. For example, an employee moves, but the address
change is corrected in only one file and not across all files in the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

data dependence

A

A data condition in which the data representation and

manipulation are dependent on the physical data storage characteristics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

data dictionary

A

A DBMS component that stores metadata—data about data.
Thus, the data dictionary contains the data definition as well as its characteristics and relationships. A data dictionary may also include data that are external to the DBMS. Also known as an information resource dictionary. See also active data dictionary, metadata, and passive data dictionary.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

data inconsistency

A

A condition in which different versions of the same data yield different (inconsistent) results.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

data independence

A

A condition that exists when data access is unaffected by changes in the physical data storage characteristics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

data integrity

A

In a relational database, refers to a condition in which the data in the database is in compliance with all entity and referential integrity constraints.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

data management

A

A process that focuses on data collection, storage, and retrieval. Common data management functions include addition, deletion, modification, and listing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

data redundancy

A

A condition that exists when a data environment contains redundant (unnecessarily duplicated) data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

data warehouse

A

Bill Inmon, the acknowledged “father of the data warehouse,” defines the term as “an integrated, subject-oriented, time-variant, nonvolatile collection of data that provides support for decision making.”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

database

A

A shared, integrated computer structure that houses a collection of related data. A database contains two types of data: end-user data (raw facts) and metadata. The metadata consist of data about data, that is, the data characteristics and relationships.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

database design

A

The process that yields the description of the database structure. The database design process determines the database components. Database design is the second phase of the database life cycle.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

database management system (DBMS)

A

Refers to the collection of programs that manages the database structure and controls access to the data stored in the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

database system

A

An organization of components that defines and regulates the collection, storage, management, and use of data in a database environment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

desktop database

A

A single-user database that runs on a personal computer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

distributed database

A

A logically related database that is stored over two or

more physically independent sites.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

enterprise database

A

The overall company data representation, which provides

support for present and expected future needs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

field

A

A character or group of characters (alphabetic or numeric) that defines a
characteristic of a person, place, or thing. For example, a person’s Social Security
number, address, phone number, and bank balance all constitute fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

file

A

A named collection of related records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

information

A

The result of processing raw data to reveal its meaning.

Information consists of transformed data and facilitates decision making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

islands of information

A

A term used in the old-style file system environment to
refer to independent, often duplicated, and inconsistent data pools created and
managed by different organizational departments.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

knowledge

A

The body of information and facts about a specific subject.
Knowledge implies familiarity, awareness, and understanding of information as it applies to an environment. A key characteristic of knowledge is that “new” knowledge can be derived from “old” knowledge.

25
Q

logical data format

A

The way in which a human being views data.

26
Q

metadata

A

Data about data, that is, data concerning data characteristics and
relationships. See also data dictionary.

27
Q

multiuser database

A

A database that supports multiple concurrent users.

28
Q

operational database

A

A database that is designed primarily to support a
company’s day-to-day operations. Also known as a transactional database or
production database.

29
Q

performance tuning

A

Activities that make a database perform more efficiently

in terms of storage and access speed.

30
Q

physical data format

A

The way in which a computer “sees” (stores) data.

31
Q

production database

A

The main database designed to keep track of the day-to-

day operations of a company. See also transactional database.

32
Q

query

A

A question or task asked by an end user of a database in the form of SQL code. A specific request for data manipulation issued by the end user or the application to the DBMS.

33
Q

query language

A

A nonprocedural language that is used by a DBMS to manipulate its data. An example of a query language is SQL.

34
Q

query result set

A

The collection of data rows that are returned by a query.

35
Q

record

A

A collection of related (logically connected) fields.

36
Q

single-user database

A

A database that supports only one user at a time.

37
Q

structural dependence

A

A data characteristic that exists when a change in the
database schema affects data access, thus requiring changes in all access
programs.

38
Q

structural independence

A

A data characteristic that exists when changes in the

database schema do not affect data access.

39
Q

Structured Query Language

A

A powerful and flexible relational database
language composed of commands that enable users to create database and table structures, perform various types of data manipulation and data administration, and query the database to extract useful information.

40
Q

transactional database

A

A database designed to keep track of the day-to-day transactions of an organization. See also production database.

41
Q

workgroup database

A

A multiuser database that supports a relatively small number of users (usually fewer than 50) or that is used for a specific department in an organization.

42
Q

attribute

A

A characteristic of an entity or object. An attribute has a name and a
data type.

43
Q

business rule

A

Narrative descriptions of a policy, procedure, or principle within
an organization. Examples: A pilot cannot be on duty for more than 10 hours during a 24-hour period. A professor may teach up to four classes during any one semester.

44
Q

class

A

A collection of like objects with shared structure (attributes) and behavior (methods). A class encapsulates an object’s data representation and a method’s implementation. Classes are organized in a class hierarchy.

45
Q

class hierarchy

A

The organization of classes in a hierarchical tree where each “parent” class is a superclass and each “child” class is a subclass. See also inheritance.

46
Q

conceptual model

A

The output of the conceptual design process. The conceptual model provides a global view of an entire database. Describes the main data objects, avoiding details.

47
Q

conceptual schema

A

A representation of the conceptual model, usually expressed graphically. See also conceptual model.

48
Q

connectivity

A

Describes the classification of the relationship between entities. Classifications include 1:1, 1:M, and M:N.

49
Q

constraint

A

A restriction placed on data. Constraints are normally expressed in the form of rules. Example: “A student’s GPA must be between 0.00 and 4.00.” Constraints are important because they help to ensure data integrity.

50
Q

Crow’s Foot notation

A

A representation of the entity relationship diagram using a three-pronged symbol to represent the “many” sides of the relationship.

51
Q

data definition language (DDL)

A

The language that allows a database administrator to define the database structure, schema, and subschema.

52
Q

data management language (DML)

A

The language (set of commands) that allows an end user to manipulate the data in the database (SELECT, INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK).

53
Q

data model

A

A representation, usually graphic, of a complex “real-world” data structure. Data models are used in the database design phase of the database life cycle.

54
Q

entity

A

Something about which someone wants to store data; typically a person, a place, a thing, a concept, or an event. See also attribute.

55
Q 
entity instance
entity occurrence (see entity instance it said for definition)
A

A term used in ER modeling to refer to a specific table row. Also known as an entity occurrence.

56
Q

entity relationship diagram (ERD)

A

A diagram that depicts an entity

relationship model’s entities, attributes, and relations.

57
Q

entity relationship (ER) model (ERM)

A

A data model developed by P. Chen in
1975. It describes relationships (1:1, 1:M, and M:N) among entities at the
conceptual level with the help of ER diagrams.

58
Q

entity set

A

In a relational model, refers to a grouping of related entities.

59
Q

extended relational data model (ERDM)

A

Sometimes referred to as the
enhanced entity relationship model; the result of adding more semantic constructs (entity supertypes, entity subtypes, and entity clustering) to the original entity relationship (ER) model.

Database (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions