Database Final chp. 2 M-C

Your page rank:

Total word count: 764
Pages: 3

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

A(n) ____’s main function is to help you understand the complexities of the real-world environment.
a. constraint c. model
b. entity d. database

c. model

A(n) ____ represents a particular type of object in the real world.
a. attribute c. relationship
b. entity d. constraint

b. entity

A(n) ____ is anything about which data are to be collected and stored.
a. attribute c. relationship
b. entity d. constraint

b. entity

A(n) ____ is the equivalent of a field in a file system.
a. attribute c. relationship
b. entity d. constraint

a. attribute

A(n) ____ is bidirectional.
a. attribute c. relationship
b. entity d. constraint

c. relationship

A(n) ____ is a restriction placed on the data.
a. attribute c. relationship
b. entity d. constraint

d. constraint

____ are important because they help to ensure data integrity.
a. Attributes c. Relationships
b. Entities d. Constraints

d. Constraints

____ are normally expressed in the form of rules.
a. Attributes c. Relationships
b. Entities d. Constraints

d. Constraints

Students and classes have a ____ relationship.
a. one-to-one c. many-to-one
b. one-to-many d. many-to-many

d. many-to-many

Business rules are derived from ____.
a. a de-tailed de-scrip-tion of an or-gani-za-tion’s oper-ations
b. standards and prac-tices de-veloped over the years
c. man-ag-ers’ rec-om-men-da-tions
d. gov-ern-men-tal over-sight or-gani-za-tion standards

a. a de-tailed de-scrip-tion of an or-gani-za-tion’s oper-ations

Which of the following is true of business rules?
a. They allow the de-sign-er to set com-pany poli-cies with re-gard to data.
b. They allow the de-sign-er to de-velop busi-ness pro-cess-es.
c. They can serve as a commu-nica-tion tool be-tween the users and de-sign-ers.
d. They pro-vide a framework for the com-pa-ny’s self actu-aliza-tion.

c. They can serve as a commu-nica-tion tool be-tween the users and de-sign-ers.

A noun in a business rule translates to a(n) ____ in the data model.
a. entity c. relationship
b. attribute d. constraint

a. entity

A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
a. entity c. relationship
b. attribute d. constraint

c. relationship

The hierarchical data model was developed in the ____.
a. 1960s c. 1980s
b. 1970s d. 1990s

a. 1960s

The object-oriented data model was developed in the ____.
a. 1960s c. 1980s
b. 1970s d. 1990s

c. 1980s

VMS/VSAM is an example of a(n) ____.
a. hierarchical model c. relational data model
b. file system data model d. XML data model

b. file system data model

Oracle 11g is an example of a(n) ____.
a. hierarchical model c. relational data model
b. file system data model d. XML/Hybrid data model

d. XML/Hybrid data model

MySQL is an example of a(n) ____.
a. hierarchical model c. relational data model
b. file system data model d. XML data model

c. relational data model

In the ____ model, the basic logical structure is represented as an upside-down tree.
a. hierarchical c. relational
b. network d. entity relationship

a. hierarchical

In the ____ model, each parent can have many children, but each child has only one parent.
a. hierarchical c. relational
b. network d. entity relationship

a. hierarchical

The relational data model was developed in the ____.
a. 1960s c. 1980s
b. 1970s d. 1990s

b. 1970s

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.
a. hierarchical c. object-oriented
b. network d. entity relationship

b. network

A(n) ____ enables a database administrator to define schema components.
a. extensible markup language (XML) c. unified modeling language (UML)
b. data definition language (DDL) d. query language

b. data definition language (DDL)

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
a. hierarchical c. object-oriented
b. network d. entity relationship

d. entity relationship

The ____ model uses the term connectivity to label the relationship types.
a. relational c. object-oriented
b. network d. entity relationship

d. entity relationship

The ____ data model is said to be a semantic data model.
a. relational c. object-oriented
b. network d. entity relationship

c. object-oriented

The ____ data model uses the concept of inheritance.
a. relational c. object-oriented
b. network d. entity relationship

c. object-oriented

One of the limitations of the ____ model is that there is a lack of standards.
a. hierarchical c. relational
b. network d. entity relationship

a. hierarchical

The ____ model is the end users’ view of the data environment.
a. abstract c. conceptual
b. external d. internal

b. external

A(n) ____ model represents a global view of the database as viewed by the entire organization.
a. external c. internal
b. conceptual d. physical

b. conceptual

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending