Question: Traffic Ticket Using Chen Model with the (min, max) notation, provide all appropriate cardinality using the following business rules: A vehicle is owned by one


Traffic Ticket Using Chen Model with the (min, max) notation, provide all appropriate cardinality using the following business rules: A vehicle is owned by one and only driver. A driver owns at least one vehicle. A law enforcement officer issues many fine tickets and a motorist may have received many fine tickets. Officer OffBadgeID OffName OffDistrict 1 2 2 issues 3 Fine Motorist MotLicense MotName MotAddress MotCity MotState MotZipcode location FineName FineDescription FineAmount ticket_id date 4 owns 5 Vehicle VehlicPlate VehColor VehYear VehVinNo 1. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the above business rules for number 1 a. (0,0) b. (0,P) C. (N,M) d. (1,1) e. (1,M) 2. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the above business rules for number 2 a. (0,N) b. (0,P) C. (NM) d. (1,1) e. (1,M) 3. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the above business rules for number 3 a. (0,N) b. (0,P) C. (N,M) d. (1,1) e. (1,M) 4. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the above business rules for number 4 a. (0,N) b. (0,P) C. (NM) d. (1,1) e. (1,M) 5. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the above business rules for number 5 a. (0,0) b. (0,P) C. (N,M) d. (1,1) e.(1,M)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
