Database Systems - Check My Understanding Chapter 2

What type of relationship is expressed with the phrase "Employee manages a Store"? a. One-to-one b. Many-to-many c. One-to-many d. Many-to-one

a. One-to-one

A way of classifying data models is by degree of _____. a. abstraction b. unification c. knowledge d. difficulty

a. abstraction

In an OO data model, a _____ is a collection of similar objects with shared structure (attributes) and behavior (methods). a. segment b. tuple c. relation d. class

a. class

A _____ is a relatively simple representation, usually graphical, of more complex real-world data structures. a. data model b. data field c. data warehouse d. data record

a. data model

A CUSTOMER _____ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit. a. entity b. relationship c. model d. constraint

a. entity

The most widely used conceptual model is the _____ model. a. entity relationship b. hierarchical c. relational d. object-oriented

a. entity relationship

Which model represents the end users' view of the data environment? a. external b. internal c. conceptual d. physical

a. external

The most important advantage of the RDBMS is that it _____. a. hides the complexities of the relational model from the user b. hinders islands of information problems as individuals and departments find it difficult develop their own applications c. is cost-effective as it reduces software overhead d. provides a bird's-eye view of the data environment that is relatively easy to understand

a. hides the complexities of the relational model from the user

A(n) _____ model maps the conceptual model to the DBMS. a. internal b. external c. implementation d. entity

a. internal

A(n) _____ model is independent of both hardware and software. a. implementation b. conceptual c. developmental d. physical

b. conceptual

A _____ is a restriction placed on the data. a. attribute b. constraint c. business rule d. entity

b. constraint

The _____ model is represented by an upside-down tree. a. entity relationship b. hierarchical c. relational d. network

b. hierarchical

The _____ model is the representation of the database as "seen" by the DBMS. a. conceptual b. internal c. external d. physical

b. internal

Which of the following is the fastest and most direct source of business rules? a. policy makers b. interviews with end users c. company documentation d. department managers

b. interviews with end users

In the OO data model, a class _____ represents a real-world action such as finding a selected PERSON's name. a. fragment b. method c. interface d. hierarchy

b. method

In a _____ model, the user perceives the database as a collection of records in one-to-many relationships, but each record is allowed to have more than one parent. a. hierarchical b. network c. relational d. column store

b. network

Which of the following data models requires the most detail in its internal model? a. relational b. network c. semantic d. entity relationship

b. network

The _____ data model is perceived as a two-dimensional structure composed of intersecting rows and columns of data. a. network b. relational c. hierarchical d. object-oriented

b. relational

Which of the following modern developments gave the use of complex objects a boost? a. creation of mainframes b. the Internet revolution c. object-oriented programming d. development of portable storage devices

b. the Internet revolution

A(n) _____ of the overall database design is required to overcome the fact that data are viewed in different ways by different people. a. footprint b. review c. blueprint d. analysis

c. blueprint

A(n) _____ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization. a. entity b. constraint c. business rule d. attribute

c. business rule

Which data model contains the most semantics? a. network b. hierarchical c. object-oriented d. relational

c. object-oriented

In the context of hierarchical structures, a _____ is the equivalent of a file system's record type. a. field b. fragment c. segment d. root

c. segment

What type of relationship is expressed with the phrase "Students take Classes"? a. One-to-one b. One-to-many c. Many-to-one d. Many-to-many

d. Many-to-many

Which model operates at the lowest level of abstraction? a. Conceptual b. Internal c. External d. Physical

d. Physical

From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the _____. a. relationships between the tables b. RDBMS c. business rules d. SQL engine

d. SQL engine

For most relational database software, the query language is _____. a. String Query Language (SQL) b. Relational Database Management System (RDBMS) c. Hadoop Distributed File System (HDFS) d. Structured Query Language (SQL)

d. Structured Query Language (SQL)

One of the advantages of a relational data model is _____. a. conceptual complexity b. complex database design c. structural dependence d. easier database design

d. easer database design

As a general rule, a noun in a business rule will translate into a(n) _____ in the model. a. attribute b. relationship c. constraint d. entity

d. entity

The object-oriented model _____. a. has a visual model that yields exceptional conceptual simplicity b. has a tabular view substantially that improves conceptual simplicity c. has a low system overhead that speeds transactions d. has objects that contain all operations that can be performed on it

d. has objects that contain all operations that can be performed on it

Database models can be grouped into two categories: conceptual models and _____ models. a. logical b. query c. physical d. implementation

d. implementation

When you can change the internal model without affecting the conceptual model, you have _____. a. conceptual separation b. structural distinction c. physical independence d. logical independence

d. logical independence

The hierarchical database model depicts a set of _____ relationships. a. many-to-one b. many-to-many c. one-to-one d. one-to-many

d. one-to-many

Within the network model, the _____ is the conceptual organization of the entire database as viewed by the database administrator. a. tuple b. segment c. entity d. schema

d. schema

XML databases have emerged to address the need to manage _____ data within the native XML format. a. structured b. relational c. object-oriented d. unstructured

d. unstructured

What type of relationship is expressed with the phrase "Painter paints one or more Paintings"? a. One-to-many b. One-to-one c. Many-to-one d. Many-to-many

a. One-to.many

The network database models have _____. a. an owner/member relationship that promotes database integrity b. a navigational system that yields simple design c. a great deal of structural independence d. a simple system that promotes efficiency

a. an owner/member relationship that promotes database intergrity

Database designers use _____ to communicate with programmers and end users. a. organization maps b. application programs c. access controls d. data models

a. data models

The term _____ refers to the task of creating a conceptual data model that could be implemented in any DBMS. a. logical design b. performance tuning c. physical access d. data structuring

a. logical design

In the _____ data model, both data and their relationships are contained in a single structure. a. object-oriented b. entity relationship c. relational d. network

a. object-oriented

The _____ model is the current database implementation standard. a. relational b. hierarchical c. network d. object-oriented

a. relational

In the _____, the three-pronged symbol is used to represent the "many" side of the relationship of the ER model. a. class diagram notation b. Crow's Foot notation c. logical design diagram notation d. Chen notation

b. Crow's Food notation

Which model operates at the highest degree of abstraction? a. Physical b. External c. Conceptual d. Internal

b. External

Which of the following data models was developed most recently? a. network b. file system c. column store d. relational

c. column store

The basic building blocks of all data models are entities, attributes, relationships, and _____. a. multiples b. business rules c. constraints d. queries

c. constraints

Each row in the relational table is known as an entity _____ in the ER model. a. attribute b. model c. instance d. relationship

c. instance

The _____ model presents a global view of the entire database. a. physical b. implementation c. logical d. conceptual

d. conceptual

The ER model uses the term _____ to label relationship types. a. matrix b. hierarchy c. table d. connectivity

d. connectivity

Data models were developed to _____. a. keep data within multiple data repositories b. extract data from virtual environment c. deposit data within a single file d. model real-world objects or events

d. model real-world objects or events

When you can change the physical model without affecting the internal model, you have _____. a. structural distinction b. logical distinction c. conceptual separation d. physical independence

d. physical independence