Final 4610
The number of entity types that participate in a relationship is referred to as the _______.
A cardinality
B attribute
C degree
D multiplicity - Answer- C degree
[Chapter 7] Conservation of inputs and outputs to a data flow diagram process when that process is decomposed t...
Final 4610
The number of entity types that participate in a relationship is referred to as the
_______.
A cardinality
B attribute
C degree
D multiplicity - Answer- C degree
[Chapter 7] Conservation of inputs and outputs to a data flow diagram process when
that process is decomposed to a lower level is referred to as _______. - Answer-
balancing
The entity-relationship model is a _______ data modeling used to capture the overall
structure of data in an organization.
A conceptual
B physical
C relational
D enterprise - Answer- A conceptual
In the ER model, a person, place, object, event or concept in the user environment
about which data is to be maintained is called a(n) _______. - Answer- entity
In the ER model, a named property or characteristic of an entity that is of interest to
the organization is referred to as a(n) _______. - Answer- attribute
The _______ is the number of instances of one entity that can be associated with
each instance of another entity.
A degree
B cardinality
C entity type
D permutation - Answer- B cardinality
In a data model for a hospital, a patient is described either as an outpatient or a
resident patient. In this model the patient represents a _______.
A super-type
B sub-type
C hierarchical type
D relational type - Answer- A super-type
In the previous hospital data model case, each patient must be either a outpatient or
a resident patient. This illustrates a case of _______ specialization
A total and disjoint
, B total and overlap
C partial and disjoint
D partial and overlap - Answer- A total and disjoint
The _______ is the set of all data types and values that an attribute can assume.
A attribute type
B cardinality
C variable
D domain - Answer- D domain
[Chapter 7] Which of the following is not proper rule that governs DFD?
A No process can have only outputs.
B Data cannot move in two opposite directions between two processes.
C Data cannot move directly from one data store to another data store.
D Data cannot move directly from an outside source to a data store. - Answer- B
Data cannot move in two opposite directions between two processes.
Which of the following is not a property of relations in the relational database
model?
A Entries in cells are simple.
B Entries in columns are from the same set of values.
C Each row is unique.
D The sequence of the rows cannot be changed. - Answer- D The sequence of the
rows cannot be changed.
________ is the process of converting complex data structures into simple, stable
data structures.
A Decomposition
B Normalization
C Rationalization
D Simplification - Answer- B Normalization
A relation is in _____ when there are no partical and transitive functional
dependendices.
A zero normal form (0NF)
B first normal form (1NF)
C second normal form (2NF)
D third normal form (3NF) - Answer- D third normal form (3NF)
A _______ is an attribute that appears as a nonprimary key attribute in one
relation and as the primary key attribute in another relation.
A candidate key
B foreign key
C secondary key
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Freshy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
