Deck 2: Data Models

Question 1

The hierarchical model is software-independent.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

Question 8

In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

Question 9

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

Question 10

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

Question 11

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

Question 12

A data model is usually graphical.

Question 13

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

Question 14

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

Question 15

Business rules must be rendered in writing.

Question 16

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

Question 17

The network model has structural level dependence.

Question 18

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

Question 19

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

Question 20

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

Question 21

A(n) _____'s main function is to help one understand the complexities of the real-world environment.

A) node
B) entity
C) model
D) database

Question 22

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

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

Question 23

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

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

Question 24

_____ are important because they help to ensure data integrity.

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

Question 25

MySQL is an example of the _____.

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

Question 26

Oracle12c, MS SQL Server, and Taminoare examples of _____ data models.

A) hierarchical
B) file system
C) relational
D) XML Hybrid

Question 27

Which of the following is true of business rules?

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

Question 28

Students and classes have a _____ relationship.

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

Question 29

_____ are normally expressed in the form of rules.

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

Question 30

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.

A) hierarchical
B) network
C) object-oriented
D) entity relationship

Question 31

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

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 32

VMS/VSAM is an example of the _____.

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

Question 33

In the _____ model, each parent can have many children, but each child has only one parent.

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

Question 34

A(n) _____ is the equivalent of a field in a file system.

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

Question 35

The hierarchical data model was developed in the _____.

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 36

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

A) attribute
B) entity
C) relationship
D) node

Question 37

A noun in a business rule translates to a(n) _____ in the data model.

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

Question 38

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

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

Question 39

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

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

Question 40

A(n) _____ is bidirectional.

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

Question 41

The relational model's foundation is a mathematical concept known as a(n) _____.

Question 42

The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

A) hierarchical
B) network
C) object-oriented
D) entity relationship

Question 43

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

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

Question 44

A(n) _____ is a relatively simple representation of more complex real-world data structures.

Question 45

A(n) _____ is the conceptual organization of an entire database as viewed by a database administrator.

Question 46

The relational data model was developed in the _____.

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 47

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

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

Question 48

In _____, a three-pronged symbol represents the "many" side of the relationship.

Question 49

A(n) _____ defines the environment in which data can be managed and is used to work with the data in the database.

Question 50

Which of the following is true of NoSQL databases?

A) They do not support distributed database architectures.
B) They are not based on the relational model.
C) They are geared toward transaction consistency rather than performance.
D) They do not support very large amounts of sparse data.

Question 51

Which of the following types of HDFS nodes stores all the metadata about a file system?

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

Question 52

Each column in a relation represents a(n) _____.

Question 53

A(n) _____ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

Question 54

Each row in a relation is called a(n) _____.

Question 55

A(n) _____ in a hierarchical model is the equivalent of a record in a file system.

Question 56

Each row in the relational table is known as a(n) _____.

Question 57

The _____ data model uses the concept of inheritance.

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

Question 58

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

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

Question 59

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

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

Question 60

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) Name node
D) Map node

Question 61

A(n) _____ is a collection of similar objects with a shared structure and behavior.

Question 62

The _____ is the representation of a database as "seen" by the DBMS.

Question 63

In object-oriented terms, a(n) _____ defines an object's behavior.

Question 64

Describe the three parts involved in any SQL-based relational database application.

Question 65

What components should an implementation-ready data model contain?

Question 66

_____ is a language based on OO concepts that describes a set of diagrams and symbols used to graphically model a system.

Question 67

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Question 68

Themovement to find new and better ways to manage large amounts of web- and sensor-generated data and derive business insight from it, while simultaneously providing high performance and scalability at a reasonable cost is referred to as "_____."

Question 69

The _____ model is the end users' view of the data environment.

Question 70

Describe the three basic characteristics of Big Data databases.

Question 71

What are the sources of business rules, and what is the database designer's role with regard to business rules?

Question 72

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

Question 73

What do business rules require to be effective?

Question 74

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _____.

Question 75

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