“Exercise 1:Fig. 1TABNAME COLCOUNT ROWCOUNT …….DEPT 3 3 ……..EMP 4 4 ……..…… …… …… ……..TABLENAME COLNAME ……DEPT DEPT# ……DEPT DNAME ……DEPT BUDGET ……EMP EMP# ……EMP ENAME ……EMP DEPT# ……EMP SALARY ………… …… ……As explained, the Catalog is self-describing-that is, it includes entries for the Catalog relvars themselves. Extend fig. 1 to include the necessary entries for the TABLE and COLUMN relvars themselves.Exercise 2:Give example of:a. A many to many relationship in which one of the participants is a weak entityb. A many to many relationship in which one of the participants is another relationshipc. A many to many relationship that has a subtyped. A subtype that has an associated weak entity that does not apply to the supertype
Exercise1 :From the given scenario, following is the catalog for vehicle management databaseTable:Table nameVehicleDriverZipcode Column683 Rowcount683 Column:Table nameVEHICLE…
