Brainscape's Knowledge GenomeTM

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


See full index

BTMA 333 > BTMA 331 Midterm > Flashcards

BTMA 331 Midterm Flashcards

1
Q

A graphical system used to capture the nature and relationships among data is called a(n)

A

data model

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

A rule that CANNOT be violated by database users is called a

A

constraint

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

The most common source of database failures in organizations is

A

failure to implement a strong database administration function

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

Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called

A

schema on write

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

Database development begins with ________, which establishes the range and general contents of organizational databases

A

enterprise data modeling

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

A departmental multi-tiered client/server database is stored on a central device called a

A

server

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

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called

A

RAD

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

In a file processing environment, descriptions for data and the logic for accessing the data are built into:

A

application programs

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

With the database approach, data descriptions are stored in a central location known as a

A

repository

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

A data warehouse derives its data from

A

various operational data sources

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

________ are established between entities in a well-structured database so that the desired information can be retrieved.

A

Relationships

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

________ specify computer systems requirements

A

Systems analysts

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

The need for consensus on data definitions is an example of which type of risk in the database environment?

A

Organizational conflict

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

A major difference between data warehouses and transactional systems as compared to big data is

A

the data is unstructured in big data systems

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

A database is an organized collection of ________ related data

A

logically

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

Specifying how data from a logical schema are stored in secondary memory is part of the

A

design.

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

Languages, menus, and other facilities by which users interact with the database are collectively called a(n)

A

user interface

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

Which organizational function should set database standards?

A

Database Administration

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

________ is a tool even non-programmers can use to access information from a database

A

Structured query language

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

Program-data dependence is caused by

A

file descriptions being stored in each database application

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

The three-schema approach includes which of the following schemas?

A

Internal

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

The SDLC phase in which the detailed conceptual data model is created is the ________ phase

A

analysis

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

Data that describe the properties of other data are:

A

metadata.

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

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

A

repository.

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

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

A

entity.

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

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

A

user view

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

Which software used to create, maintain, and provide controlled access to databases?

A

Database management system (DBMS)

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

The traditional methodology used to develop, maintain, and replace information systems is called the:

A

Systems Development Life Cycle

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

A user view is:

A

a logical description of some portion of the database

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

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase.

A

analysis

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

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship

A

mandatory one

31
Q

A relationship between the instances of a single entity type is called a ________ relationship.

A

unary

32
Q

A property or characteristic of an entity type that is of interest to the organization is called a(n):

A

attribute.

33
Q

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

A

composite identifier

34
Q

An entity that associates the instances of one or more entity types and contains attributes peculiar to the relationships is called a(n):

A

associative entity.

35
Q

An attribute of an entity that is computed is a(n):

A

derived attribute

36
Q

The total quiz points for a student for an entire semester is a(n) ________ attribute.

A

derived

37
Q

A person’s name, birthday, and social security number are all examples of:

A

attributes.

38
Q

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

A

cardinality constraint

39
Q

A fact is an association between two or more:

A

terms.

40
Q

A value that indicates the date or time of a data value is called a:

A

time stamp

41
Q

Data modeling may be the most important part of the systems development process because:

A

data characteristics are important in the design of programs and other systems components.

42
Q

A ________ defines or constrains some aspect of the business.

A

business rule

43
Q

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

A

ternary

44
Q

The most common types of entities are:

A

strong entities

45
Q

An attribute that must be present for every entity (or relationship) instance is a(n):

A

required attribute.

46
Q

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

A

2

47
Q

An attribute that can be calculated from related attribute values is called a ________ attribute.

A

derived

48
Q

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

A

many-to-many

49
Q

An entity type whose existence depends on another entity type is called a ________ entity.

A

weak

50
Q

The number of entity types that participate in a relationship is called the:

A

degree.

51
Q

Customers, cars, and parts are examples of:

A

entities.

52
Q

The number of entity types that participate in a Unary relationship is:

A

1

53
Q

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

A

composite

54
Q

A(n) ________ is the relationship between a weak entity type and its owner.

A

identifying relationship

55
Q

When all multivalued attributes have been removed from a relation, it is said to be in:

A

first normal form

56
Q

A primary key that consists of more than one attribute is called a:

A

composite key

57
Q

A two-dimensional table of data sometimes is called a:

A

relation.

58
Q

A constraint between two attributes is called a(n):

A

functional dependency.

59
Q

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.

A

partial functional

60
Q

Data is represented in the form of:

A

tables

61
Q

The entity integrity rule states that

A

no primary key attribute can be null.

62
Q

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

A

primary key.

63
Q

The attribute on the left-hand side of the arrow in a functional dependency is the:

A

determinant

64
Q

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

A

referential integrity constraint.

65
Q

________ anomalies can be caused by editing data in tables

A

Modification

66
Q

A functional dependency between two or more nonkey attributes is called a:

A

transitive dependency.

67
Q

The normal form which deals with multivalued dependencies is called

A

fourth normal form

68
Q

When a regular entity type contains a multivalued attribute, one must:

A

create two new relations, one containing the multivalued attribute.

69
Q

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

A

foreign key

70
Q

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

A

Boyce-Codd normal form.

71
Q

A relation that contains minimal redundancy and allows easy use is considered to be

A

well-structured

72
Q

An alternative name for an attribute is called a(n):

A

alias

73
Q

_________ is the maintenance and assurance of the accuracy and consistency of data over its entire life-cycle, ensuring it remains unaltered and uncorrupted from creation and storage to retrieval and processing.

A

Data integrity

74
Q

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

A

second

75
Q

The ________ states that no primary key attribute may be null.

A

entity integrity rule

76
Q
A

BTMA 333 (2 decks)

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