Zoo Questions 4 section 01 IT 340 01 Introduction to Database Systems Google Chrome Secure |https://mnsu.ims.mnscu.edu/d2/le/content/3770851/fullscreen/32422961/Niew Zoo Questions 4 section 01 Zoo Questions 4 The purpose of this assignment to understand simple SQL statements and answer questions based on the Zoo database schema Assignment Requirements Run the Zoo database's "FULL_DATABASE_with_DROP" script to create the tables and insert data for these questions. Questions 1. Select each member's first name, last name, and their membership type title 2. List the employee (s) first name, last name, zoo ID, and research bonus amount for those who have received a research bonus of more than $5,000 3. What association does the vet Ann Moore belong to? Find all the medications prescribed by the vet, Bryan Booth List the prescription dosage and the medication type List Lhe employee irs name, employee last name, olfice building and department name for all the employees that have an office and depart.ment. 6Display the animal ID, animal name, their prescription dosage and medication instructions for animals born in March of any Zoo Questions 4 section 01 IT 340 01 Introduction to Database Systems Google Chrome Secure |https://mnsu.ims.mnscu.edu/d2/le/content/3770851/fullscreen/32422961/Niew Zoo Questions 4 section 01 Zoo Questions 4 The purpose of this assignment to understand simple SQL statements and answer questions based on the Zoo database schema Assignment Requirements Run the Zoo database's "FULL_DATABASE_with_DROP" script to create the tables and insert data for these questions. Questions 1. Select each member's first name, last name, and their membership type title 2. List the employee (s) first name, last name, zoo ID, and research bonus amount for those who have received a research bonus of more than $5,000 3. What association does the vet Ann Moore belong to? Find all the medications prescribed by the vet, Bryan Booth List the prescription dosage and the medication type List Lhe employee irs name, employee last name, olfice building and department name for all the employees that have an office and depart.ment. 6Display the animal ID, animal name, their prescription dosage and medication instructions for animals born in March of any