one page singled

7.

A rental car agency classifies the vehicles it rents into four cate-gories: compact, midsize, full size, and sport utility. The agencywants to record the following data for all vehicles: Vehicle ID,Make, Model, Year, and Color. There are no unique attributes for any of the four classes of vehicle. The entity type vehiclehas a relationship (named Rents) with a customer entity type.None of the four vehicle classes has a unique relationshipwith an entity type. Would you consider creating a supertype/subtype relationship for this problem? Why or why not?

9.

A bank has three types of accounts: checking, savings, andloan. Following are the attributes for each type of account:CHECKING: Acct No, Date Opened, Balance, ServiceChargeSAVINGS: Acct No, Date Opened, Balance, Interest RateLOAN: Acct No, Date Opened, Balance, Interest Rate,PaymentAssume that each bank account must be a member ofexactly one of these subtypes. Using generalization, developan EER model segment to represent this situation using thetraditional EER notation, the Visio notation, or the subtypesinside supertypes notation, as specified by your instructor.Remember to include a subtype discriminator