Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started