DBMS: Mapping of EER to Relational model

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 พ.ย. 2024
  • This video explain about how to convert EER model to relational model. ie. specialization/ generalization , union to relational schema.

ความคิดเห็น • 8

  • @AbhiudaiShahi
    @AbhiudaiShahi 3 หลายเดือนก่อน

    nice

  • @adityanegi2533
    @adityanegi2533 2 หลายเดือนก่อน

    Thank you

  • @VithuVithursan-r9s
    @VithuVithursan-r9s 8 หลายเดือนก่อน

    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  7 หลายเดือนก่อน +1

      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.

  • @ebtehalm8601
    @ebtehalm8601 7 หลายเดือนก่อน

    how to map inheritance (tree structure) ?

  • @amruth505
    @amruth505 หลายเดือนก่อน

    can we combine different options to one relational mapping?

    • @computerengineeringvideo5813
      @computerengineeringvideo5813  หลายเดือนก่อน

      Yes it is possible, for example in specialization you can use Option 8A,8B, 8C, 8D depends on number of attributes of superclass , subclasses.