1 / 5

Understanding Attribute Inheritance and Supertype/Subtype Relationships in EER Diagrams

This document explores the concept of attribute inheritance in the context of supertype and subtype entities. Attribute inheritance allows a supertype to encapsulate the attributes of its subtypes, simplifying information management. The importance of this feature lies in its ability to streamline data representation. It also discusses the disjoint and overlap rules in supertype/subtype relationships with examples involving students categorized by GPA and programs. Additionally, the role of business rules in defining entity relationships is examined through EER diagrams.

halen
Télécharger la présentation

Understanding Attribute Inheritance and Supertype/Subtype Relationships in EER Diagrams

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Joshua Mason CH 4 part 1 Questions 11, 12, 13

  2. Question 11 -What is the attribute inheritance? Why is it important? Attribute inheritance is when a Super type picks up all of the subtype entities. This is important to help break down or simplify information we need.

  3. Question 12 • Give an example of each of the following • A supertype/ subtype relationship there the disjointed rule applies Student d 3.0-4.0GPA 2.0-2.9GPA 0-1.9GPA

  4. A supertype/subtype relationship where the overlap rule applies. Student o Business Cosc Sportsr

  5. Question 13 Relationships between entity types are business rules normally captured in an EER diagram.

More Related