BTMA 331 Midterm

Question 1

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

Answer 1

data model

Question 2

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

Answer 2

constraint

Question 3

The most common source of database failures in organizations is

Answer 3

failure to implement a strong database administration function

Question 4

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

Answer 4

schema on write

Question 5

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

Answer 5

enterprise data modeling

Question 6

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

Answer 6

server

Question 6

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

Answer 6

RAD

Question 7

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

Answer 7

application programs

Question 8

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

Answer 8

repository

Question 9

A data warehouse derives its data from

Answer 9

various operational data sources

Question 10

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

Answer 10

Relationships

Question 11

________ specify computer systems requirements

Answer 11

Systems analysts

Question 12

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

Answer 12

Organizational conflict

Question 13

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

Answer 13

the data is unstructured in big data systems

Question 14

A database is an organized collection of ________ related data

Answer 14

logically

Question 15

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

Answer 15

design.

Question 16

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

Answer 16

user interface

Question 17

Which organizational function should set database standards?

Answer 17

Database Administration

Question 18

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

Answer 18

Structured query language

Question 19

Program-data dependence is caused by

Answer 19

file descriptions being stored in each database application

Question 20

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

Answer 20

Internal

Question 21

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

Answer 21

analysis

Question 22

Data that describe the properties of other data are:

Answer 22

metadata.

Question 23

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

Answer 23

repository.

Question 24

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

Answer 24

entity.

Question 25

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

Answer 25

user view

Question 26

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

Answer 26

Database management system (DBMS)

Question 27

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

Answer 27

Systems Development Life Cycle

Question 28

A user view is:

Answer 28

a logical description of some portion of the database

Question 29

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.

Answer 29

analysis

Question 30

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

Answer 30

mandatory one

Question 31

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

Answer 31

unary

Question 32

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

Answer 32

attribute.

Question 33

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

Answer 33

composite identifier

Question 34

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

Answer 34

associative entity.

Question 35

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

Answer 35

derived attribute

Question 36

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

Answer 36

derived

Question 37

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

Answer 37

attributes.

Question 38

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

Answer 38

cardinality constraint

Question 39

A fact is an association between two or more:

Answer 39

terms.

Question 40

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

Answer 40

time stamp

Question 41

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

Answer 41

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

Question 42

A ________ defines or constrains some aspect of the business.

Answer 42

business rule

Question 43

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

Answer 43

ternary

Question 44

The most common types of entities are:

Answer 44

strong entities

Question 45

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

Answer 45

required attribute.

Question 46

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

Answer 46

2

Question 47

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

Answer 47

derived

Question 48

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.

Answer 48

many-to-many

Question 49

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

Answer 49

weak

Question 50

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

Answer 50

degree.

Question 51

Customers, cars, and parts are examples of:

Answer 51

entities.

Question 52

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

Answer 52

1

Question 53

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

Answer 53

composite

Question 54

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

Answer 54

identifying relationship

Question 55

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

Answer 55

first normal form

Question 56

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

Answer 56

composite key

Question 57

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

Answer 57

relation.

Question 58

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

Answer 58

functional dependency.

Question 59

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.

Answer 59

partial functional

Question 60

Data is represented in the form of:

Answer 60

tables

Question 61

The entity integrity rule states that

Answer 61

no primary key attribute can be null.

Question 62

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

Answer 62

primary key.

Question 63

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

Answer 63

determinant

Question 64

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

Answer 64

referential integrity constraint.

Question 65

________ anomalies can be caused by editing data in tables

Answer 65

Modification

Question 66

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

Answer 66

transitive dependency.

Question 67

The normal form which deals with multivalued dependencies is called

Answer 67

fourth normal form

Question 68

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

Answer 68

create two new relations, one containing the multivalued attribute.

Question 69

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

Answer 69

foreign key

Question 70

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

Answer 70

Boyce-Codd normal form.

Question 71

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

Answer 71

well-structured

Question 72

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

Answer 72

alias

Question 73

_________ 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.

Answer 73

Data integrity

Question 74

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?

Answer 74

second

Question 75

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

Answer 75

entity integrity rule