Using the following database, answer the following questions. Before Running this script, you'll need to create a database (you can choose the name) and ensure it's active (bolded in mysql). Answer the following questions about the database using SQL Statements. For each Question, please use an Alias for the table name and include your initials as one of the Aliases. (MY INTIAL is A Z) Please only submit the SQL Statements for the answers, use the template as an answer sheet.What customer addresses are on a "Lane or Ln?"What's the address to all businesses that were incorporated after Jan 1, 2000?How many individuals were born before 1970? What's the average available and pending balance for all accounts at each Branch? (use Group by) Which accounts have a difference between their Available and Pending Balance?How many employees does Paula Roberts Supervise?Who are the employees work that work at each Branch? Write an SQL Statement to add a new teller to Headquarters and an IT Manager to headquarters. Make up the information for the other columns.Write an SQL Statement to add a Database Administrator to the headquarters staff, please use your name for this statement. Submit answer sheet to these problems.

Notes: Store input values into their declared variables and not use textboxes directly in expression.Summary: In this assignment you create a program to convert feet and inches to meter. The conversion is done with a function you write in the program and then call it. Input data: Feet: User enters a number for feet Period: User enters a number for inches Instructions: Create a new project and name it as yourlastname-firstname-Assignment5. Save this project in VB folder you created earlier. Change form’s title to: Your full name – Assignment 5 - Conversion. Form contains four Labels, two TextBoxes, and three Button controls. Use labels to identify Feet, Inches and Meters. See below Form Layout with Controls for more details. Note: You will use the same control Names shown below. - Input variables: Feet (Single) - TextBox, txtFeet Inches (Single) - TextBox, txtInches - Output variables: Meters (Single) -Label, lblMeters To convert feet and inches to meters, use this formula: (feet * 12 + inches) * 0.0254. 0.0254 is a constant value to convert English system to Metric. Make sure to declare a Constant for this literal number. You construct a Function for this conversion. It will be placed after End Sub for btnConvert_Click. Start the Function code with typing Function keyword, followed by the function name, followed by parameters, followed by function type. This Function has two parameters; feet and inches. See below for suggested program's infrastructure. Items to note:. Variables names must follow the conventions and rules explained earlier and must have proper data type for the values that will be stored in them. Appearance of the form is very important; Make sure that your design is clean; Spelling is important. Clear button, clears TextBoxes and Label control that displays Meters. Exit button, closes the Form. You will write the code for the three buttons. Avoid double-clicking on TextBox and Label Controls to create unnecessary code. If you do, please delete them. Run the program, enter values for Feet and Inches, then click Convert button, to see the Meters equivalent displays in the Label control. See example for the complete program below. Note: If you leave TextBoxes blank when program is running, your program would crash. Avoid testing with blank TextBoxes. We will learn how to solve this problem. To save the project, from File, select Save All. Continue with SaveAll after making changes. Once project is complete, open File Explorer; open VB folder and you will see a folder named: yourlastname-firstname-Assignment5. This folder contains a folder and a solution file with SLN extension. Both are named the same. Solution file (.SLN) and the folder containing VB necessary files to run the project.

I have to do the commands on the documents but it is very confusing, and I need help finishing assignments.