Draw EERD and relational schema of following case study
Draw an EER diagram for the following description of a law firm: Each case handled by the firm has a unique case number; a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plaintiffs, and the same plaintiff may be involved in many cases. A plaintiff has a requested judgment characteristic. A case is against one or more defendants and the same defendant may be involved in many cases. A plaintiff or defendant may be a person or an organization. Over time, the same person or organization may be a defendant or a plaintiff in cases. In either situation, such legal entities are identified by an entity number, and other attributes are name and net worth. A database is required for judiciary to keep record of law. The organization wants to keep record of prisoner and their cases information. The prisoner has the unique number name address . the perisoner commit different type of crimes. The crime has unique number, punishment type and duration. The crime can be medium, low and high risk crime. Minimum security prisons are usually reserved for white collar criminals who have committed acts such as embezzlement or fraud. Although these are serious crimes, they are non-violent in nature and therefore the perpetrators are not considered to be a risk for violence. These perpetrators are sent to facilities that offer a dormitory-type living environment, fewer guards, and more personal freedoms, The characteristic of this type is living environment and punishment duration. Medium security prisons are the standard facilities used to house most criminals. They feature cage-style housing, armed guards, and a much more regimented daily routine than minimum security. The attributes for this type of crime are punishment amount High security prisons are reserved for the most violent and dangerous offenders. These prisons include far more guards than both minimum and medium security, and very little freedom. Each person confined to such a prison is considered to be a high-risk individual. The attributes of high security risk are date of committed crime and severity level. The persior may commit one or all type of crime. The crime committed by any prisoner have hearing. The cases are of two type either the cases has been closed and their final result has been saved. Or the hearing is continues. In case of continues case the date of next hearing and record of previous findings are store. DRAW EERD