CS6400 - Chapter 2 Questions with Detailed Verified Answers
a client module will run on
Ans: typically a mobile device, user workstation, or personal computer (PC)
a server module typically
Ans: handles data storage, access, search, etc
data abstraction refers to
Ans: suppression of details of data organization and storage. Highlights *essential*
features for an improved understanding
data model is a
Ans: collection of concepts that can be used to describe a structure of a DB
dynamic aspect or behavior allows the DB designer to
Ans: specify a set of valid user-defined operations that are allowed on the DB objects,
popularly known as stored procedures
conceptual data models provide
Ans: concepts that are close to the way many users perceive data
low level or physical data models provide
© Get it right 2025 Getaway - Stuvia US All rights reserved
, Click here for more: Scholars nexus
Ans: concepts that describe the detail of how data is stored on storage media
representational (or implementation) data models provide
Ans: concepts that may be easily understood by end users but are not too far removed
from the way data is organized in computer storage
representational (or implementation) data models are used most frequently in
Ans: traditional commercial DBMS
conceptual data models use concepts such as
Ans: entities (real-world object/concept), attributes (property of interest) and
relationships (entities with an association)
physical data models describe how data
Ans: is stored as files on the computer such as record formats, record orderings, and
access paths.
an index is an example of
Ans: an access path that allows direct access to data using an index term or keyword
self-describing data models combine
Ans: the description of the data with the data values themselves (XML or other key-
value stores, JSON)
schema diagram displays
© Get it right 2025 Getaway - Stuvia US All rights reserved