SER 322 Midterm Exam | Questions and Answers (Complete Solutions)
16 views 0 purchase
Course
SER 322
Institution
SER 322
SER 322 Midterm Exam | Questions and Answers (Complete Solutions) What is a Composite attribute? A. An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity B. An attribute that holds multiple values for a single comp...
A. An attribute that represents a value that is derivable from a related attribute or set of
attributes, not necessarily in the same entity
B. An attribute that holds multiple values for a single component
C. An attribute composed of multiple components each with individual existence
D. An attribute that holds a single value for a single entity
E. An attribute composed of a single component with an independent existence
A condition that an entity can be a member of at most one of the subclasses of the
specialization is called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint
A condition that an entity can be a member of more than one of the subclasses of the
specialization is called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint
A condition that every entity in the superclass must be a member of some subclass in
the specialization/ generalization is called ______________.
A. completeness constraint
B. overlapping constraint
,C. disjointness constraint
D. predicate constraint
An entity is ____________.
A. an inanimate object in an application
B. a collection of items in a mini-world
C. a distinct object or thing in a mini-world
D. data structure
An entity that does not have sufficient attributes to form a primary key is termed a
__________.
A. Variant
B. Strong entity
C. Weak entity
D. Variable
In an E-R diagram entities are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles
, In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles
In an E-R diagram Relationship Set are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles
A double rectangle represents a:
Weak Set
Relationship types of degree 3 are called _______________.
A. ternary
B. binary
C. n-ary
Suppose:
VEHICLE is a superclass{CAR, TRUCK} are subclasses of VEHICLEVEHICLE is a
_____________________of {CAR, TRUCK}.
A. union-type
B. specialization
C. generalization
D. category
What is Specialization?
A. the process of defining a set of subclasses of a superclass
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 Jumuja. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
