Write 2 to 3pagesUsing a data dictionary, you will write an SQL command to satisfy a data retrieval request. To view the sample dictionary and data retrieval request, click here (Links to an external site.)Links to an external site.. You can also obtain a copy of the document in Files. The details for this assignment are provided in the Course Project for Week 7 in Introduction & Resources.Submit your lab.Week 7Written Assignment: Data Evaluation Your system has been implemented at the Medical Center of DeVry and you have been requested to produce a report of data from the system.Using a data dictionary, you will write an SQL command to satisfy a data retrieval request. The sample dictionary and data request are as follows.Data DictionaryPatient TableElementDefinitionTyprLengthDefaultConstraintsMR#Unique identification numberNumeric9None100000000-999999999LNameIndividual’s last nameAlpha25NoneNoneFNameIndividual’s first nameAlpha20NoneNoneGenderIndividual’s genderAlpha1None"F" or "M"BdateIndividual’s birth dateDate8NoneNoneData Retrieval RequestList all patients with the last name of “Johnson”.List all patients who are female.List all patient last names and the medical record number of each.Important InstructionFor guidance on using SQL commands, refer to the Course Resources, SQL webpages provided, Week lesson area, and other reliable resources of your choice.SQL11 hours agoo SQL and free tutorialsFree SQL tutorialshttp://www.sql.org/o Free SQL TutorialsFree SQL tutorialshttp://www.sqlcourse.com/index.html

For this assignment you will research the mental health of either Frida Kahlo or Vincent Van Gogh. Both of these artists created many self-portraits. Your job is to determine whether we can see signs of mental illness within her or his self-portrait.You must then select two articles to analyze their work:One of these articles should be about one or more of her or his self-portraits.The other article should be about assessing mental illness through observation OR an article discussing the mental illness of either Kahlo or Van Gogh.Requirements:Write a 500-700 word essay in which you analyze the research on her or his mental illness.Analyze one or more self-portraits by either Kahlo or Van Gogh. Do you believe the portrait reflects how the artist was feeling at the time? Why or why not? Argue whether you believe it possible to diagnose someone who is no longer living based on an image of them? How?What are the challenges scholars face when considering the mental illness of artists?Please see the rubric for how this assignment will be graded.