LIS3874 Quiz Questions

¡Supera tus tareas y exámenes ahora con Quizwiz!

____ 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


Conjuntos de estudio relacionados

ATP 2-33.4 : Appendix B : Intelligence Analysis : Cognitive Considerations for Intelligence Analysts

View Set

Yawp Chapter 26, Chapter 25, Week 9 Quiz, Ch. 23, The American Yawp Chapter 30

View Set

Chapter 8 Quiz: Spring 2021 BIO-215-OL-A: Nutrition

View Set

Hurley MKT 232 Chapter 11-15 Quizzes

View Set

Electric & Magnetic Forces: Facts and Concepts

View Set

Ecological Responses to Global Climate Change: Exam 1

View Set