Chapter 2 Flashcards

1
Q

A data model is usually graphical.

A

True

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

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

A

True

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

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

A

False

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

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

A

False

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

Business rules must be rendered in writing.

A

True

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

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

A

True

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

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

A

True

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

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

A

True

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

The network model has structural level dependence.

A

True

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

The hierarchical model is software-independent.

A

False

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

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

A

Model

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

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

A

Entity

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

A(n) ____ is bidirectional.

A

Relationship

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

____ are important because they help to ensure data integrity.

A

Constraints

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

Students and classes have a ____ relationship.

A

Many to many

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

Which of the following is true of business rules?

A

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.

17
Q

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

A

Relationship

18
Q

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

19
Q

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

A

XML/Hybrid data model

20
Q

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

A

Hierarchichal

21
Q

The relational data model was developed in the ____.

22
Q

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

A

Data definition language (DDL)

23
Q

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

A

Entity relationship

24
Q

The ____ data model uses the concept of inheritance.

A

Object-oriented

25
The ____ model is the end users’ view of the data environment.
External
26
The terms data model and database model are often used interchangeably.
True
27
A manager and a programmer usually have the same view of the same data.
False
28
In an SQL-based relational database, each table is dependent on another.
False
29
In Chen notation, entities and relationships must be oriented horizontally.
False
30
The entity relationship model is limited to conceptual modeling, with no implementation component.
True
31
A(n) ____ represents a particular type of object in the real world.
Entity
32
Business rules are derived from ____.
-a detailed description of an organization’s operations standards and practices developed over the years managers’ recommendations governmental oversight organization standards
33
MySQL is an example of a(n) ____.
a relational data model
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.
Network
35
The ____ data model is said to be a semantic data model.
Object-oriented
36
A(n) ____ model represents a global view of the database as viewed by the entire organization.
Conceptual