Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Question
All data in a database are stored in ____ files.a. table
b. data
c. RAM
d. system
Answer
This answer is hidden. It contains 1 characters.
Related questions
Q:
An example of denormalization is using a ____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.a. transitive b. 3NF c. componentd. temporary
Q:
A table is in 4NF if it is in 3NF and ____.
a. all attributes must be dependent on the primary key, and must be dependent on each other
b. all attributes are unrelated
c. has no multivalued dependencies
d. no column contains the same values
Q:
In what two cases are composite primary keys particularly useful?
Q:
Describe specialization and generalization.
Q:
What do specialization hierarchies do?
Q:
Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed ____________________ in the M:N relationship.
Q:
____________________ completeness means that every supertype occurrence must be a member of at least one subtype.
Q:
Subtypes that contain nonunique subsets of the supertype entity set are known as ____________________ subtypes.
Q:
Disjoint subtypes are also known as ____________________ subtypes.
Q:
____ data refer to data whose values change over time and for which you must keep a history of the data changes.a. Time-sensitive b. Time-variant c. Historicald. Change-based
Q:
Surrogate primary keys are especially helpful when there is no ____ key.a. primary b. natural c. foreignd. composite
Q:
The most important characteristic of an entity is its ____ key, used to uniquely identify each entity instance.a. primary b. natural c. foreignd. surrogate
Q:
At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a(n) ____ relationship.a. self-referencing b. 1:1 c. 1:Md. M:N
Q:
One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.a. primary b. natural c. foreignd. surrogate
Q:
A specialization hierarchy can have ____ level(s) of supertype/subtype relationships.a. zerob. only one c. one or manyd. many
Q:
Within a specialization hierarchy, every subtype can have ____ supertype(s) to which it is directly related.a. zero b. only one c. one or manyd. many
Q:
A design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.
Q:
The completeness constraint can be partial or total.
Q:
Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
Q:
When indicating cardinality, the first value represents the ____________________ number of associated entities.
Q:
The ____________________ refers to a specific table row as an entity instance.
Q:
In the ERD, cardinality is indicated using the ____ notation.a. (max, min) b. (min, max) c. [min ... max]d. {min|max}
Q:
A derived attribute ____.
a. must be stored physically within the database
b. need not be physically stored within the database
c. has many values
d. must be based on the value of three or more attributes
Q:
The ____ attribute(s) make up the primary key in the table definition:CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)a. CRS_CODE b. CLASS_SECTION c. CRS_CODE and CLASS_SECTIONd. There is no primary key
Q:
A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Q:
A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
Q:
A relationship is identified by a name that describes the relationship.
Q:
Derived attributes are stored in a special database table.
Q:
Ideally, a primary key is composed of several attributes.
Q:
Attributes are types of entities.