Reference no: EM133389162

Question: Explain the option/mandatory relationship between the parolee and case in this erd case

Convicts may be eligible to be placed on parole after serving a minimum percentage of their prison sentence. While on parole, they are still under strict supervision by parole officers. For example, a convict given an 8-year prison sentence may serve 5 years in jail and then 3 years on parole. Only convicts that have been granted parole will be kept in this system. Each parolee is given a parolee number. Since, unfortunately, many criminals return to jail many times, it is possible for a person to be placed on parole many times throughout their lifetime. For simplicity, each time a person is placed on parole, it is referred to as a parole case or just a "case". Even if the person commits other crimes later and ends up back in jail and on a different case at a later time, the same parolee number is used for that person. In addition to the parolee number, the parolee's name, date of birth, ethnicity, and date of death are recorded in the system. Note that date of death will only have a value if the person dies after being placed on parole. Each time a person is placed on a case, certain data must be recorded about the case - the date the parole case is approved by the parole board, the date the parole case begins (i.e., the date the parole begins), and the date the parole case is scheduled to end are recorded when the parole board approves the parolee for parole. Also, the individual's height, weight, hair color, and eye color at the time the parole case begins (recorded on the day that they are released from holding) are also recorded in the system. Each case is associated with only one parolee