LIS3874 Quiz Questions
____ is a generic entity type that is related to one or more entity subtypes.
An entity supertype
The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
CRS_CODE and CLASS_SECTION *underlined*
____ are important because they help to ensure data integrity.
Constraints
A ____ database supports data distributed across several different sites.
Distributed
____ might be represented with a multivalued attribute.
Household phone numbers
____ data can have only a true or false (yes or no) values
Logical
A(n) ____ might be represented with a single-valued attribute
SSN
A desktop database is a ____ database
Single -user
. A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
Workgroup
Business rules are derived from ____.
a detailed description of an organization's operations
A table that displays data redundancies most likely yields ____.
anomalies
A(n) ____ is the equivalent of a field in a file system.
attribute
A ____ identifier is composed of more than one attribute.
composite
The ERD represents the ____ database as viewed by the end user
conceptual
A(n) ____ is a restriction placed on the data
constraint
Data redundancy produces ____.
data integrity problems
____ yields better performance.
denormalization
In the context of a database table, the statement "A ____ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.
determines
The set of possible values for an attribute is a ____.
domain
The extended entity relationship model (EERM) is sometimes referred to as the ____.
enhanced entity relationship model
A(n) ____ database is used by an organization and supports many users across many departments
enterprise
A(n) ____ is anything about which data are to be collected and stored.
entity
The relational database model enables you to view data ____ rather than ____.
logically, physically
A derived attribute ____.
need not be physically stored within the database
Within a specialization hierarchy, every subtype can have ____ supertype(s) to which it is directly related.
only one
A ____ could be a derived attribute.
person's age
One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.
primary
In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable
primary keys
An attribute that is part of a key is known as a(n) ____ attribute.
prime
The response of the DBMS to a query is the ____.
query result set
A ____ attribute can have only one value
single-valued
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
specialization hierarchy
The relational model's creator, E. F. Codd, used the term relation as a synonym for ____.
table
Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages (foms) are as high as you need to go in the normalization process.
three
In a text-based ER description, primary keys are indicated by ____.
underlining