1 / 12

EER: Enhanced E-R Model

EER: Enhanced E-R Model. Specialization / Generalization SubClass / SuperClass. Subclasses for Different Roles. SuperClass: Staff SubClasses: Manager SalesPersonnel Secretary. Common and Different Attributes. SuperClass:

kolton
Download Presentation

EER: Enhanced E-R Model

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. EER: Enhanced E-R Model Specialization / Generalization SubClass / SuperClass

  2. Subclasses for Different Roles SuperClass: Staff SubClasses: Manager SalesPersonnel Secretary

  3. Common and Different Attributes SuperClass: Staff: staffNo, name, address, phone, salary SubClasses: Manager: mgrStartDate, bonus SalesPersonnel: salesArea, carAllowance Secretary: typingSpeed

  4. Different Entities for Subclasses?

  5. Constraints for Sub-Classes Participation: Mandatory Optional Disjoint: Disjoint (or) Non-disjoint (and) Business Rules

  6. Participation: Mandatory SuperClass: Staff SubClasses PartTime FullTime

  7. Participation: Optional SuperClass: Staff SubClasses Supervisor Supervisee

  8. Disjoint (Xor) SuperClass: Staff SubClasses PartTime FullTime

  9. Nondisjoint (And) SuperClass: Staff SubClasses: Manager SalesPersonnel Secretary

  10. Staff staffNo Manager bonus Secretary typingSpeed SalesPersonnel salesArea EER Diagram {Mandatory, And}

  11. Staff staffNo FullTime salaryScale PartTime hoursRate EER Diagram {Mandatory, Xor}

  12. EER is Optional for Assignment 3

More Related