Chapter 2

Question 1

A data model is usually graphical.

Answer 1

True

Question 2

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

Answer 2

True

Question 3

Data modeling starts with a very complex representation, and as knowledge of the problem is gained, the model is simplified.

Answer 3

False

Question 4

Database designers determine the data and information that yield the required understanding of the entire business.

Answer 4

False

Question 5

Business rules must be rendered in writing.

Answer 5

True

Question 6

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

Answer 6

True

Question 7

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

Answer 7

True

Question 8

M:N relationships are not appropriate in a relational model.

Answer 8

True

Question 9

The network model has structural level dependence.

Answer 9

True

Question 10

The hierarchical model is software-independent.

Answer 10

False

Question 11

A(n) ____’s main function is to help you understand the complexities of the real-world environment.

Answer 11

Model

Question 12

A(n) ____ is anything about which data are to be collected and stored.

Answer 12

Entity

Question 13

A(n) ____ is bidirectional.

Answer 13

Relationship

Question 14

____ are important because they help to ensure data integrity.

Answer 14

Constraints

Question 15

Students and classes have a ____ relationship.

Answer 15

Many to many

Question 16

Which of the following is true of business rules?

Answer 16

They allow the designer to set company policies with regard to data.

They allow the designer to develop business processes.

-They can serve as a communication tool between the users and designers.

They provide a framework for the company’s self actualization.

Question 17

A verb associating two nouns in a business rule translates to a(n) ____ in the data model.

Answer 17

Relationship

Question 18

The object-oriented data model was developed in the ____.

Answer 18

1980s

Question 19

Oracle 11g is an example of a(n) ____.

Answer 19

XML/Hybrid data model

Question 20

In the ____ model, the basic logical structure is represented as an upside-down tree.

Answer 20

Hierarchichal

Question 21

The relational data model was developed in the ____.

Answer 21

1970s

Question 22

A(n) ____ enables a database administrator to define schema components.

Answer 22

Data definition language (DDL)

Question 23

The ____ model uses the term connectivity to label the relationship types.

Answer 23

Entity relationship

Question 24

The ____ data model uses the concept of inheritance.

Answer 24

Object-oriented

Question 25

The ____ model is the end users’ view of the data environment.

Answer 25

External

Question 26

The terms data model and database model are often used interchangeably.

Answer 26

True

Question 27

A manager and a programmer usually have the same view of the same data.

Answer 27

False

Question 28

In an SQL-based relational database, each table is dependent on another.

Answer 28

False

Question 29

In Chen notation, entities and relationships must be oriented horizontally.

Answer 29

False

Question 30

The entity relationship model is limited to conceptual modeling, with no implementation component.

Answer 30

True

Question 31

A(n) ____ represents a particular type of object in the real world.

Answer 31

Entity

Question 32

Business rules are derived from ____.

Answer 32

-a detailed description of an organization’s operations

standards and practices developed over the years

managers’ recommendations

governmental oversight organization standards

Question 33

MySQL is an example of a(n) ____.

Answer 33

a relational data model

Question 34

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.

Answer 34

Network

Question 35

The ____ data model is said to be a semantic data model.

Answer 35

Object-oriented

Question 36

A(n) ____ model represents a global view of the database as viewed by the entire organization.

Answer 36

Conceptual