Reference no: EM133257861
Question: Parking Pass System.
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.