Database Management For Information Systems 1-5

Front 1

A picutre of the high-level entities for an organization and the relationships among the entities is called an

A Logical data model
B Hypertext graphic
C Erd
D Physical data model
E None of the above

Back 1

e. planning enterprise model

Front 2

Each row in a table represents an _______________ of an entity

Back 2

Instance

Front 3

A relatively small team of people who collaborate on the same project is called a ____________?

Back 3

Workgroup

Front 4

A generic planning methodology that attempts to gain a broad understanding of the organization’s information needs is called _____________ planning.

Back 4

Top-down

Front 5

The SDLC phase in which database processing programs are created is the ______________ phase.

Back 5

Implementation

Front 6

A database is an organized collection of ______________ related data.

Back 6

Logically

Front 7

Data that describes the properties of other data are _______________ ?

Back 7

Metadata

Front 8

A Local area network-based environment in which a databases server performs commands sent to it from client workstations is called an ______________ architecture.

Back 8

Client/server

Front 9

Which of the following conditions can exist if an associative entity is to be created?

a. All the relationships for the participating entities are one-to-one.
b. The new associative entity has independent meaning.
c. The new associative entity participate in independent relationships.
d. A and B
e. B and C

Back 9

e. B and C

Front 10

An entity type whose existence depends on another entity is a __________?

Back 10

Weak entity

Front 11

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

Back 11

Identifying relationship

Front 12

An attribute that can be broken down into smaller parts is called a ___________ attribute.

A. associative
B. simple
C. composite
D. complex
E. none of the above

Back 12

C. composite

Front 13

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called

Back 13

Associative entity

Front 14

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

Back 14

Degree

Front 15

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

Back 15

Ternary

Front 16

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

Back 16

Cardinality constraint

Front 17

The most common type of entity is …..

Back 17

Strong entity

Front 18

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

Back 18

Attributes

Front 19

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

Back 19

Many-to-many

Front 20

The __________ rule specifies that an entity can be a member of only one subtype at a time.

Back 20

Disjoint

Front 21

A statement that defines or constrains some aspect of the business is called…

Back 21

Business rule

Front 22

A specification of the characteristics of the data values that can be associated with one or more attributes is a(n)….

Back 22

Domain constraint

Front 23

An attribute that uniquely identifies each row in a relation is called a ….

Back 23

Candidate key (can be a primary key)

Front 24

________________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are

Back 24

Data integrity

Front 25

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

Back 25

Referential integrity constraint

Front 26

Which of the following are anomalies that can be caused by redundancies in tables?

a. Insertion
b Deletion
c Modification
d. All of the above
e None of the above

Back 26

d. All of the above

Front 27

An address is a ___________ attribute.

Back 27

Composite (can be broken down)

Front 28

A single occurrence of an entity is called an entity _____________

Back 28

Instance

Front 29

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

Back 29

Well-structured

Front 30

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

Back 30

Functional dependency

Front 31

The process of defining one or more subtypes of a supertype and forming relationships is called ….

Back 31

Specialization

Front 32

A relation that contains no multi-valued attributes, but has non-key attributes not dependent on the primary key is in which normal form?

Back 32

First

Front 33

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 ________________ entity.

Back 33

partial function

Front 34

Two or more attributes having different names is

Back 34

synonyms

Front 35

How many relations will result from a binary one-to-one relationship?

Back 35

Two

Front 36

How many relations will result from a binary many-to-many relationship?

Back 36

Three

Front 37

How many relations will result from a unary one-to-one relationship?

Back 37

One

Front 38

How many relations will result from a ternany many-to-many relationship?

Back 38

Four

Front 39

Duplication of data in files may cause _________?

a. Data integrity problems
b. Data items with different names in different files
c. Data items with the same name used for different purposes
d. All of the above

Back 39

d. All of the above