Ch. 2 Quiz

A noun in a business rule translates to a(n) _______ in the data model. • entity • attribute • constraint • relationship

entity

A verb associating two nouns in a business rule translates to a(n) ______ in the data model. - entity - constraint - attribute - relationship

entity

In the _____ model, each parent can have many children, but each child has only one parent. - network - relational - entity relationship - hierarchical

network

The relational data model was developed in the _____ - 1970s - 1980s - 1960s - 1990s

1970s

Which of the following is true of NoSQL databases? • They do not support distributed database architectures. • They are not based on the relational model. • They are geared toward transaction consistency rather than performance. • They do not support very large amounts of sparse data.

They are not based on the relational model.

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

true

Which of the following is true of business rules? • 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.

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

A(n) _____ is the equivalent of a field in a file system. - attribute - entity - constraint - relationship

attribute

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS? - Map node - Client node - Data node - Name node

client mode

A(n) ______ is a restriction placed on the data. - attribute - constraint - entity - relationship

constraint

______ are important because they help to ensure data integrity. - Constraints - Relationships - Attributes - Entities

constraints

______ are normally expressed in the form of rules. - Constraints - Entities - Relationships - Attributes

constraints

A(n) ______ enables a database administrator to describe schema components - unified modeling language (UML) - extensible markup language (XML) - query language - data definition language (DDL)

data definition language (DDL)

A(n) _______ enables a database administrator to describe schema components - data definition language (DDL) - query language - extensible markup language (XML) - unified modeling language (UML)

data definition language (DDL)

A(n) _____ is anything about which data are to be collected and stored. - relationship - attribute - constraint - entity

entity

A(n) _____ represents a particular type of object in the real world. - relationship - node - attribute - entity

entity

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 - object-oriented - hierarchical - entity relationship

entity relationship

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

false

A(n) ______'s main function is to help one understand the complexities of the real-world environment. - database - entity - model - node

model

Which of the following types of HDFS nodes stores all the metadata about a file system? - Name node - Data node - Map node - Client node

name node

The _____ data model is said to be a semantic data model. - relational - entity relationship - object-oriented - network

object-oriented

The ______ data model uses the concept of inheritance. - object-oriented - relational - entity relationship - network

object-oriented

Students and classes have a ______ relationship - many-to-many - many-to-one - one-to-one - one-to-many

one-to-many

The _____ model uses the term connectivity to label the relationship types. • entity relationship • relational • object-oriented • network

entity relationship

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

entity relationship