Chapter 4 Fundamentals of DB Systems Midterm Exam And 100% Accurate Answers.
5 views 0 purchase
Module
Fundamentals of Database Systems
Institution
Fundamentals Of Database Systems
Subclass or Subtype of an entity type - Answer The numerous subgroupings of an entity that are meaningful and need to be represented explicitly because of their significance to the database application
Super class or supertype - Answer The entity for which a subtype belongs
Class/subcla...
Chapter 4 Fundamentals of DB Systems
Midterm Exam And 100% Accurate
Answers.
Subclass or Subtype of an entity type - Answer The numerous subgroupings of an entity that are
meaningful and need to be represented explicitly because of their significance to the database
application
Super class or supertype - Answer The entity for which a subtype belongs
Class/subclass relationship - Answer The relationship between a super class in any of it subclasses
Type inheritance - Answer When an entity that is a member of a subclass in here it's all the attributes
of the entity as a member of the superclass
Specialization - Answer The process of defining a set of subclasses of an entity type
Specific or local attributes - Answer Attributes that apply only to entities of a particular subclass
Generalization - Answer Suppressing the differences among several entity types, identifying their
common features, and then generalizing them into a single superclass of which the original entity types
are special subclasses. In other words the process of defining a generalized entity type from the given
entity types
Predicate - defined/condition - defined subclasses - Answer A condition placed on The value of an
attribute in the super class, which will determine exactly the entities that will become members of each
subclass.
Attribute - defined specialization - Answer When all subclasses in the specialization have their
membership condition on the same attributes of the superclass
, User - defined subclass - Answer When we do not have a condition for determining membership in a
subclass
Disjointness constraint - Answer A constraint that specifies that the subclasses of the specialization
must be disjoint sets. This means that an entity can be a member of at most one of the subclasses of the
specialization.
Overlapping constraint - Answer And entity may be a member of more than one subclassed of the
specialization this case, which is the default, is displayed by placing in O in the circle
Completeness or totalness constraint - Answer Specifies that every entity in the superclass must be a
member of at least one subclass in the specialization
Disjointness, completeness - Answer Two constraints that applied to a specialization
Partial specialization - Answer Allows an entity NOT to belong to any of the subclasses
True - Answer In general a super class that was addenda fied through the generalize Asian process
usually is total, because the superclass is derived from the subclasses and hence contains only the
entities that are in the subclasses
Total generalization - Answer When a superclass contains only the entities that are in the subclasses
True - Answer Disjointness constraints are independent. The four possible constraints on a
specialization are disjoint, total
Disjoint, partial
Overlapping, total
Overlapping, partial
True - Answer Deleting an entity for my superclass implies that it is automatically deleted from all the
subclasses to which it belongs
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 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 TestSolver9. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.97. You're not tied to anything after your purchase.
