DBMS: Mapping of EER to Relational model

Поделиться
HTML-код
  • Опубликовано: 17 фев 2024
  • This video explain about how to convert EER model to relational model. ie. specialization/ generalization , union to relational schema.

Комментарии • 4

  • @ebtehalm8601
    @ebtehalm8601 2 месяца назад

    how to map inheritance (tree structure) ?

  • @user-mr9rc1pb1l
    @user-mr9rc1pb1l 3 месяца назад

    but mam,in the 8c method , the super class already has a attribute that is "jobtype".....then how did you add the "job type" as a type attribute in the scema....

    • @computerengineeringvideo5813
      @computerengineeringvideo5813  3 месяца назад

      The type (or discriminating) attribute whose value indicates the subclass to which each tuple belongs. This option works only for a
      specialization whose subclasses are disjoint. In this example job_type is also the attribute of superclass. So the same you can use as a flag attribute For example if the Bank Account is of two types 1. Saving Account & 2. Current Account ; so in this case you can use aacount_type as a type attribute.