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
Which of the following is a specialization hierarchy overlapping constraint scenario in case of partial completeness?a. Subtype sets are unique.
b. Supertype has optional subtypes.
c. Subtype discriminators cannot be null.
d. Subtype does not have a supertype.
Answer
This answer is hidden. It contains 1 characters.
Related questions
Q:
Unique values can be better managed when they are________ , because the database can use internal routines to implement a counter-style attribute that automatically increments values with the addition of each new row.
Q:
The____________ is the result of adding more semantic constructs to the original entity relationship (ER) model.
Q:
A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.
a. True
b. False
Q:
A determinant is any attribute whose value determines other values within a column.
a. True
b. False
Q:
It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.
a. True
b. False
Q:
A table is in 2NF if it is in 1NF, and it includes no partial dependencies.
a. True
b. False
Q:
Converting a database format from 1NF to 2NF is a complex process.
a. True
b. False
Q:
In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.
a. True
b. False
Q:
Repeating groups must be eliminated by ensuring that each row defines a single entity.
a. True
b. False
Q:
A table is in BCNF if every determinant in the table is a foreign key.
a. True
b. False
Q:
Normalization is a process that is used for changing attributes to entities.
a. True
b. False
Q:
From a data modeling point of view, ___________--data refer to data whose values change over time and for which one must keep a history of the data changes.
Q:
The " __________________" characteristic of a primary key states that the primary key must uniquely identify each entity instance, must be able to guarantee unique values, and must not contain nulls.a. unique valuesb. nonintelligentc. preferably single-attributed. security-complaint
Q:
A primary key's main function is to uniquely identify a(n)_______________ within a table.a. attributeb. entity instance or rowc. entity subtyped. natural key or identifier
Q:
An entity cluster is formed by combining multiple interrelated entities into_______________ .a. a single abstract entity objectb. multiple abstract entity objectsc. a single entity objectd. multiple entity objects
Q:
______________is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.a. Specializationb. Generalizationc. Normalizationd. Total completeness
Q:
Overlapping subtypes are subtypes that contain_______--- subsets of the supertype entity set.a. nullb. exclusivec. solitaryd. nonunique
Q:
Nonoverlapping subtypes are subtypes that contain a(n)________ subset of the supertype entity set.a. entityb. subtypesc. uniqued. nonunique
Q:
At the implementation level, the supertype and its subtype(s) depicted in a specialization hierarchy maintain a(n)__________ relationship.a. self-referencingb. 1:1c. 1:Md. M:N
Q:
What components should an implementation-ready data model contain?
Q:
In_________________________ , a threepronged symbol represents the "many" side of the relationship.
Q:
Each row in a relation is called a(n)_______________ .
Q:
A(n) ________________is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
Q:
The relational data model was developed in the_______ . a. 1960s b. 1970sc. 1980s d. 1990s
Q:
MySQL is an example of the____________ .a. hierarchical model b. file system data modelc. relational data model d. XML data model
Q:
Students and classes have a ____________relationship.a. one-to-one b. one-to-manyc. many-to-one d. many-to-many
Q:
A(n)__________ is a restriction placed on the data.a. attribute b. entityc. relationship d. constraint
Q:
A(n)________ 's main function is to help one understand the complexities of the realworld environment.a. node b. entityc. model d. database
Q:
The hierarchical model is software-independent.a. Trueb. False
Q:
The external model is the representation of the database as "seen" by the DBMS.
a. True
b. False