First, create a MySql database or use an existing database (make sure to use a UTF8 character set) and then create a table in the database called "Ages": CREATE TABLE Ages ( name VARCHAR(128), age INTEGER ) Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands: DELETE FROM Ages; INSERT INTO Ages (name, age) VALUES ('Rosalie', 29); INSERT INTO Ages (name, age) VALUES ('Nancy', 36); INSERT INTO Ages (name, age) VALUES ('Cesare', 29); INSERT INTO Ages (name, age) VALUES ('Alyx', 27); INSERT INTO Ages (name, age) VALUES ('Maanav', 15); Once the inserts are done, run the following SQL command: SELECT sha1 (CONCAT (name, age)) AS X FROM Ages ORDER BY X Find the first row in the resulting record set and enter the long string that looks like 254c6127cdbc4c38e065317667340e8b0950046f (this is just a sample string).

I'm asking for help with different perspectives on purpose. Also, you do not have to complete the code, I’m posting the entire question in order for the question to be clear. Sorry if you see this question ask more than once.   Objectives:  The main objective of this assignment is to assess the student’s ability to provide a complete Black-Box testing plan for a computer program.    Description:  you will need to design a complete Black-Box testing plan for the following program. Instead of changing passwords every semester, students will now change passwords once a month. Unfortunately, the school has realized that many students are bad at picking their passwords. Ideally, passwords alternate between letters, numbers, and symbols. However, most students and faculty pick passwords such as “12345password”. To make matters worse, when students and faculty are forced to change their password, usually only a single character is added to the end of their previous password. Due to this…

4

Purpose: One of the most commonly made decisions is based on comparing the means of multiple conditions. Significance tests for comparing means are critical in the decision making process. In this assignment, you will practice how to use t tests and ANOVA tests to compare the means of multiple conditions under one independent variable in different experiment design (between-group and within-group) Tasks: Please write an R script that performs the following operations in the order listed. At the beginning of each task, write a comment marking the task number. Name the file as: lab6-<your last name>.R  ANOVA tests 8. Import the 'iris.csv' dataset. Browse and understand the data in each column 9. Compute descriptive statistics and create boxplot for sepal length and species. 10. Select the appropriate test to determine whether there is significant difference in sepal length between the three species. Follow the steps of ANOVA analysis. Make sure you check whether the assumptions are…