What is a Composite attribute? - ANSWER An attribute composed of
multiple components each with individual existence
A condition that an entity can be a member of at most one of the
subclasses of the specialization is called ______________. - ANSWER
disjointness constraint
A condition that every entity in the superclass must be a member of
some subclass in the specialization/ generalization is called
______________. - ANSWER completeness constraint
An entity is ____________. - ANSWER a distinct object or thing in a
mini-world
An entity that does not have sufficient attributes to form a primary key is
termed a __________. - ANSWER Weak entity
In an E-R diagram entities are represented by _______________. -
ANSWER rectangles
Relationship types of degree 3 are called _______________. -
ANSWER ternary
Suppose:
VEHICLE is a superclass {CAR, TRUCK} are subclasses of
VEHICLEVEHICLE is a _____________________of {CAR, TRUCK}. -
ANSWER generalization
What is Specialization? - ANSWER the process of defining a set of
subclasses of a superclass
What is a Derived attribute? - ANSWER An attribute that represents a
value that is derivable from a related attribute or set of attributes, not
necessarily in the same entity
, What is a Single-valued attribute? - ANSWER An attribute that holds a
single value for a single entity
What is a Multi-valued attribute? - ANSWER An attribute that holds
multiple values for a single component
What is a Simple attribute? - ANSWER An attribute composed of a
single component with an independent existence
What type of relationship is described by the following rule? For one
instance of entity A, there exists zero, one, or many instances of entity
B; and for one instance of entity B, there exists zero, one, or many
instances of entity A. Select the best answer.
1:1 relationship
1:N relationship
M:N relationship
No answer text provided. - ANSWER M:N relationship
What type of relationship is described by this rule? For one instance of
entity A, there exists zero, one, or many instances of entity B; but for one
instance of entity B, there exists zero or one instance of entity A. Select
the best answer.
1:1 relationship
1:N relationship
M:N relationship
No answer text provided. - ANSWER 1:N relationship
_____ is a attribute (or a set of attributes) in a database relation that has
a unique value. - ANSWER Super Key
_____ constraint dictates that the foreign key must contain values that
match the primary key in the related table, or must contain null. -
ANSWER Referential Integrity
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 luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.