Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database Systems > Chapter 2 Data Models > Flashcards

Chapter 2 Data Models Flashcards

1
Q

The network model has structural level dependence.

True or False?

A

True

Chapter 2 page 42

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

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

True or False?

A

: True

Chapter 2

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

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?

A. Data node
B. Client node
C. Map node
D. Name node

A

Client node

Chapter 2 page 53

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

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

True or False?

A

True

Chapter 2

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

The ___ data model is said to be semantic data model.

A. network
B. entity relationship
C. relational
D. object-oriented

A

: object-oriented

Chapter 2

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

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

A. relationship
B. constraint
C. attribute
D. entity

A

: relationship

Chapter 2

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

A(n) is a restriction placed on the data.

A. relationship
B. attribute
C. constraint
D. entity

A

: constraint

Chapter 2

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

A data model is usually graphical.

True or False?

A

: True

Chapter 2

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

Students and classes have a ___ relationship.

A. many-to-many
B. many-to-one
C. one-to-many
D. one-to-one

A

: Many-to-many

Chapter 2

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

Within the database environment, a data model represents data structures with the purpose of supporting a problem domain.

True or False?

A

: True

Chapter 2

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

NoSQL databases:

A. support only small amounts of sparse data.
B. are based on the relational model
C. are geared toward transaction consistency; not performance
D. provide fault tolerance

A

: provide fault tolerance

Chapter 2

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

VMS/VSAM is an example of the ___.

A. XML data model
B. relational data model
C. hierarchical model
D. file system data model

A

: file system data model

Chapter 2

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

An internal ___ refers to a specific representation of an internal model, using the database constructs supported by the chosen database.

A. tuple
B. value
C. object
D. schema

A

: schema

Chapter 2 page 42

Schema is a logical grouping of database objects, such as tables, indexes, views, and queries, that are related to each other.

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

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

True or False?

A

: False

Chapter 2

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

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

A. entity relationship
B. network
C. relational
D. object-oriented

A

: object-oriented

Chapter 2

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

Today, most relational database products can be classified as object/relational.

True or False?

A

: True

Chapter 2

17
Q

A noun in a business rule translate to a(n) ___ in the data model.

A. relationship
B. constraint
C. attribute
D. entity

A

: entity

Chapter 2

18
Q

One of the limitations of the ___ model is that there is a lack of standards.

A. entity relationship
B. hierarchical
C. relational
D. network

A

: hierarchical

Chapter 2

19
Q

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

True of False?

A

False

Chapter 2

20
Q

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

A. attribute
B. entity
C. constraint
D. relationship

A

: relationship

Chapter 2

21
Q

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

True or False?

A

False

Chapter 2

22
Q

___ are normally expressed in the form of rules.

A. Relationships
B. Constraints
C. Attributes
D. Entities

A

: Constraints

Chapter 2

23
Q

A(n) ___ is bidirectional.

A. constraint
B. entity
C. relationship
D. attribute

A

: relationship

Chapter 2

24
Q

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

A. object-oriented
B. relational
C. entity-relationship
D. network

A

: entity relationship

Chapter 2

25
Q

A(n) ___ enables a database administrator to describe schema components.

A. query language
B. extensible markup language (XML)
C. unified modeling language (UML)
D. data definition language (DDL

A

: data definition language

Chapter 2

26
Q

Oracle 11g is an example of the ___.

A. XML/Hybrid data model
B. file system data model
C. hierarchical model
D. relational data model

A

: XML/Hybrid data model

Chapter 2

27
Q

Which of the following is true of business rules?

A. They allow the designer to develop business process.
B. They can serve as a communication tool between the users and designers.
C. They provide a framework for the company’s self-actualization.
D. They allow the designer to set company policies with regard to data.

A

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

Chapter 2

28
Q

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

True or False?

A

: True

Chapter 2

29
Q

The external model is the representation of the database as “seen” by the DBMS.

True or False?

A

: True

Chapter 2

Database Systems (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions