Rental car agency classifies the vehicles it rents into four categories: compact, midsize, full size, and sport utility

Rental car agency classifies the vehicles it rents into four categories: compact, midsize, full size, and sport utility

rental car agency classifies the vehicles it rents into four categories: compact, midsize, full size, and sport utility. The agency wants 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 vehicle h as a relationship (named Rents) with a customer entity type. None of the four vehicle classes has a unique relationship with an entity type. Would you consider creating a super type/subtype relationship for this problem? Why or why not? A bank has three types of accounts: checking, savings, an d loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge SAVINGS: Acct No, Date Opened, Balance, Interest Rate LOAN: Acct No, Date Opened, Balance, Interest Rate ,Payment Assume that each bank account must be a member of exactly one of these subtypes. Using generalization, develop an EER model segment to represent this situation using the traditional EER notation, the Visio notation, or the subtypes inside super types notation, as specified by your instructor. Remember to include a subtype discriminator

Solution preview for the order on Rental car agency classifies the vehicles it rents into four categories: compact, midsize, full size, and sport utility

APA

466 words