Draw a complete ERD that depicts the data model to record the required information. The data model must be neat and professional in appearance. The assignment must be completed through your individual efforts giving or seeking assistance from anyone other than the instructor is not permitted. The final ERD should be in a single MS Word document and uploaded to D2L. Southern Clinic for Abuse Rehabilitation Services (SCARS) is a specialty clinic that helps individuals deal with substance abuse issues. They are not prepared for, and do not treat, all mental and/or emotional disorders. Primarily, SCARS works with individuals that present themselves for treatment; however, they also work with some COSAT (court ordered substance abuse treatment) patients. All patients are treated on an outpatient basis. SCARS is attempting to get government funding to support their operations so they need to improve the ease with which they can produce a variety of reports. You have been contracted to develop a database to support tracking the patients they work with. Your design should support the following operations. Description of Operations: When a patient comes to SCARS, the staff will diagnose them so the staff will know what they are working with. Each new patient is assigned an identification number that is recorded along with the patients name, address, and whether or not he or she is a COSAT patient. Patients come in knowing that they suffer from some kind of chemical dependency disorder. In addition, many patients also suffer from one or more other disorders, such as depression or paranoia, that they are not aware is a disorder. If the staff thinks a patient suffers from a disorder that SCARS cannot deal with, then the staff refer that patient to a local full-care hospital. Such patients will appear in SCARS system, but will not be associated with a disorder since SCARS will not make an official diagnosis for them. Each disorder has an identification code, a name, a general description, and a description of the pattern of family incidence (e.g. tends to appear on the mothers side of the family, tends to appear on the fathers side of the family, no hereditary characteristic, etc.). Each disorder is associated with symptoms that help to identify the disorder. Each symptom has a name, a general description, and a location on the body where it occurs. Every disorder will have one or more symptoms. Some symptoms are common to many different disorders, but all symptoms must be associated with at least one disorder. A patient may be diagnosed with one or more disorders. SCARS may expand their capabilities in the future so the system should support disorders with which no patient has been diagnosed. Whenever a patient is diagnosed with a disorder, the date of that diagnoses, the severity of the Page 2 of 2 disorder in that patient, and a prognosis (forecast for the likely recovery from the disorder) are recorded. For example, when Henry Peterson first came to SCARS for help with alcohol abuse, he was diagnosed with severe alcohol dependency, severe depression, and moderate panic disorder. The prognoses for his alcohol dependency and depression are poor; for his panic disorder, the prognosis is good. When a patient first comes to SCARS and at regular intervals afterward, the medical staff conduct an evaluation of the patient. This is when a SCARS medical staff member will examine and interview the patient to identify the symptoms that they are exhibiting and make a diagnosis, if needed. Most of the time, a new patient will be diagnosed during the first evaluation, but patients that cannot be treated at SCARS do not receive a diagnosis, as mentioned above. It is possible for follow-up evaluations to result in a new diagnosis, but that is unusual. When a patient makes his or her initial visit to SCARS, he or she may have to wait for a medical staff member to become available before their initial evaluation occurs, so the system should allow the patient information to be stored before the staff conduct an evaluation. Each evaluation is performed on a single patient by a single medical staff member. Over time, a single staff member can perform many evaluations on the same patient. Whenever an evaluation is performed, even evaluations that do not result in a diagnosis, the date of the evaluation, any symptoms observed, and any notes the staff may want to record need to be saved in the system. The staff at SCARS includes both medical and non-medical personnel. Medical personnel include therapists, nurses, nurse practitioners, and physicians assistants. All medical personnel must have a license number, license type, and date of licensure in the system. Additionally, medical personnel must have an emergency contact number on file. Non-medical staff members include a variety of business, housekeeping, and clerical personnel. The system should retain an employee number, name, hire date, and title for all staff members. Only medical personnel can perform an evaluation, but new medical personnel may not have performed any evaluations yet. Federal reporting places great emphasis on the initial diagnosis of a patient with a disorder. Some local physicians and the court system occasionally send patients to SCARS. These patients will come into the system with an initial diagnosis already made, even before they have the first evaluation. SCARS will receive data on these patients before the patient ever shows up at SCARS for the initial evaluation. The system must be able to enter and track these patients and their diagnoses before the patient receives an evaluation that is tracked by the SCARS system. Therefore, it is possible to have diagnoses for a patient even if the patient does not have an evaluation. Some evaluations do not lead to a diagnosis, but all evaluations must be recorded. A single evaluation can lead to a patient being diagnosed with several different disorders. Each diagnosis of a patient with a disorder only needs to be associated with the single evaluation that originally led to that diagnosis. For example, staff diagnosed Henry Peterson with alcohol dependency, depression and panic disorder during his initial evaluation. Over the next six months, staff evaluated Henry three more times. During a later evaluation, staff determined that he also suffers from post-traumatic stress disorder