Database:

1. What is an entity supertype, and why is it ysed? AN Given the following ERD ANS: List: SuperTvee Entity List: Subtype Entity EMPLOYEE DEPENDENT SUPERTYPE PK,FK1EMP NUM PK PK EMP NUM DPNT NUM Shared Attributes (Attributes inherited by all subtypes) EMP LNAME EMP FNAME EMP INITIAL EMP HIRE DATE EMP TYPE DPNT FNAM DPNT LNAME DPNT RELATION Inherited Relationship Category Symbol DisjointOverlapping Constraint (d /o d) EMP TYPESubtype Discriminator Partial/Complete Constraint PILOT MECHANIC ACCOUNTANT PK,FK1 EMP NUM ACT TITLE PK,FK1 EMP NUM PK,FK1 EMP NUM Unique Attributes PIL LICENSE PIL RATINGS PIL_MED_TYPE MEC TITLE MEC CERT ACT CPA DATE(Attributes unique to subtypes) SUBTYPES