Chapter 2 Quiz- Data Models

Your page rank:

Total word count: 540
Pages: 2

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

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

False

An implementation-ready data model needn’t necessarily contain enforceable rules to guarantee the integrity of the data.

Falsea dis

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

True

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

True

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

True

Business rules must be rendered in writing.

True

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

True

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

False

The hierarchical model is software-independent.

False

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

False

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

True

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

False

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

True

The relational model is hardware-dependent and software-independent.

False

The network model has structural level dependence

True.

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

False

Even when a good database blueprint is available, an applications programmer’s view of the data should match that of the manger and the end user.

False

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?
a) Map Node
b) Name Mode
c) Data Node
d) Client Node

d) Client Node

A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
a) Constraint
b) Relationship
c) Attribute
d) Entity

b) Relationship

In the _____ model, each parent can have many children, but each child has only one parent.
a) Entity Relationship
b) Hierarchical
c) Relational
d) Network

b) Hierarchical

The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
a) Hierarchical
b) Entity Relationship
c) Network
d) Object-oriented

b) Entity Relationship

The _____ data model is said to be a semantic data model.
a) Network
b) Entity Relationship
c) Object-oriented
d) Relational

c) Object-oriented

NoSQL databases:
a) Are based on the relational model.
b) Provide fault tolerance
c) Support only small amounts of sparse data
d) Are geared toward transaction consistency; not performance

b) Provide fault tolerance

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined ______.
a) Business norms
b) Business Rules
c) Business Plans
d) Business Goals

b) Business Rules

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

b) Constraints

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

c) relational data model

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

c) 1960s

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