IS 300 Ch. 2

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

Crow's Foot notation

A disadvantage of the relational database management system (DBMS) is its inability to hide the complexities of the relational model from the user (T/F)

F

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. (T/F)

F

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories (T/F)

F

Database designers determine the data and information that yield the required understanding of the entire business (T/F)

F

In Chen notation, entities and relationships have to be oriented horizontally; not vertically (T/F)

F

The external model is the representation of the database as "seen" by the DBMS (T/F)

F

Oracle 12c, MS SQL Server, and Tamino are examples of ___ data models

XML Hybrid

A model's main function is to

help one understand the complexities of the real-world environment

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

hierarchical

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

internal model

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

schema

The hierarchical data model was developed in the

1960s

A data definition language (DDL) enables a

database administrator to descrive schema components

The relational data model was developed in the

1970s

The object-oriented data model was developed in the

1980s

A noun is a business rule translates to a(n) __ in the data model

Entity

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 (T/F)

F

In an SQL-based relational database, each table is dependent on every other table (T/F)

F

In the __ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have ore than one parent

Network

A data model is usually graphical (T/F)

T

An implementation-ready data model should contain a description of the data structure that will store the end-user data (T/F)

T

Business rules must be rendered in writing (T/F)

T

Today, most relational database products can be classified as object/relational (T/F)

T

An entity represents

a particular type of object in the real world

The entity relationship model was developed to

allow designers to use a graphical tool to examine structures rather than describing them with text

An entity is

anything about which data are to be collected and stored

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

attribute

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 data

b. They are not based on the relational model

A relationship is

bidirectional

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

business rule

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

class

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

data manipulation language (DML)

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

data model

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

entity instance

An attribute is the

equivalent of a field in a file system

The ___ model is the end users' view of the data environment

external

VMS/VSAM is an example of the

file system data model

Constraints are normally expressed in the

form of rules

Constraints are important because they

help to ensure data integrity

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

hierarchical

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

logical design

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

method

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

relation

MySQL is an example of the

relational data model

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

relationship

A constraint is a

restriction placed on the data

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

schema

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

segment

The object-oriented data model is said to be a

semantic data model

The entity relationship model uses the

term connectivity to label the relationship types

The hierarchical model is software-independent

F

The movement 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 "_____."

Big data

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

C

The relational model is hardware-dependent and software-independent (T/F)

F

The _____ data model uses the concept of inheritance

Object-oriented

Each row in the relational table is known as an entity instance or entity occurrence in the ER model (T/F)

T

In an SQL-based relational database, rows in different tables are related based on common values in common attributes (T/F)

T

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored (T/F)

T

M-N relationships are not appropriate in a relational model (T/F)

T

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain (T/F)

T

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

business rules

Students and classes have a _____ relationship

many-to-many

Each row in a relation is called a(n)

tuple