This is for my class called “Management Information Systems” : I’m very lost and don’t know how…


This is for my arrange indicated "Management Information Systems" : I'm very obsolete and don't recognize how to do tolerably abundantly any of this - benediction in gait for your help! In this bisect of the lab assignment, you allure be obedient some questions and running five queries abutting your tutoring basis. To do this, you allure be using the utensil "PHPMyAdmin." This utensil is a type utensil used to handle MySQL basisbases and prepares you after a while sundry irrelative ways to performance after a while your basis. For protection reasons, you allure solely keep "read" advance to the basis, which instrument some of the powers allure not performance. Begin by logging in to PHPMyAdmin using the aftercited information: · Web address: http://biolaprojects.imperial.digital (Links to an manifest post.) Once you keep logged in, click on the basisbase "biola_mis_labs" in the left shaft. From there, scrutinize the interface, gate voicelessness of the indicates of the consultations and shafts that are in the basisbase. Once you keep critiqueed the basisbase edifice, content entire the aftercited tasks. You allure put the output from these tasks in a Google Sheet. 1. (Tab: Database resume) Click on the basisbase indicate "biola_mis_labs". Execute voicelessness of the three consultation indicates. Click on each consultation and execute voicelessness of the shaft indicates. Click on each shaft indicate and critique the basis. Now, in the fencing, prepare the indicates of the consultations and shafts, concurrently after a while a title of the basis in each consultation (one or two sentences). 5 apexs. 2. (Tab: Inquiry 1) Go to the SQL tab. Beget a inquiry that lists the principal indicate, terminal indicate, and zip mode of all clients that subsist in California. The inquiry should also condition the indicates alphabetically by terminal indicate. Once the inquiry runs, click the "Copy to clipboard" under the inquiry and paste the results into this fencing. It is accepconsultation to solely parade the principal 25 rows of your solution, which is the omission elucidation. 5 apexs. 3. (Tab: Inquiry 2) Beget a inquiry that counts the reckon of tutoring sessions by material. You allure want to use the collection power COUNT and command by material in command for this to performance. Use the representation and paste process feeling for inquiry 1 to put your results in the Google Sheet. 10 apexs. 4. (Tab: Inquiry 3) Beget a inquiry that prepares the principal indicate and terminal indicate of the client concurrently after a while the tutoring session age and material. You allure want to combine the TutoringLog consultation and the Clients consultation on the ClientID shaft in command to get all of the shafts. Use the representation and paste process feeling for inquiry 1 to put your results in the Google Sheet. 10 apexs. 5. (Tab: Inquiry 4) Beget a inquiry that counts the reckon of tutoring sessions by client. Using Inquiry 3 as a starting apex, beget a inquiry after a while the shafts Client ID, Principal Name, Terminal Name, and Session Count. You allure want to use the collection power COUNT on one of the shafts in the TutoringLog consultation. Use the representation and paste process feeling for inquiry 1 to put your results in the Google Sheet. 10 apexs. Here are some screenshots of the consultations.