A parking garage has two types of parking pass: daily pass and monthly pass. A customer who
Question:
A parking garage has two types of parking pass: daily pass and monthly pass. A customer who purchases a daily pass should deposit/prepaid parking fee in the pass. A customer who purchases a monthly pass should prepaid monthly fee but enjoys his/her own reserved parking lot. Each pass must have a type and be exactly one of these two types (cannot be two types at the same time). Following are the attributes for each type of parking passes
▪ DailyPass: PassNum, PassName, BenefitDescription, FeeBalance
▪ MonthlyPass: PassNum, PassName, BenefitDescription, BeginDate, EndDate, ReservedLot, CarBrand, CarModel, CarColor, CarLicensePlate
You should move the common attributes into the supertype and leave the unique attributes in the corresponding subtypes.
Create the EERD for the system.