Questions: 1. Terminology: For each description below, give the appropriate term to match the description (Hint: Remember terms are bolded in the text). a. There is a table that lists the different stores a retail location operations and different attributes about each store is contained in a column of the table. One of these attributes is location and another lists the date the store was first opened. b. Employees are listed in a payroll database. There is a field that contains numbers that the employees are given upon hire, and no two employees have the same number. c. Someone writes code that will search the database to tell their boss how many deliveries they have made to Hawaii in the past month. d. In a hospital database, there is a patient table, and every line in the table contains information from a patient. e. A firm has a policy that only gives permission to alter or change data already stored in the database. f. A field in a table listing delivery addresses has numbers that uniquely identify which customer is attached to the delivery. 2. SQL Statement: For each description below, ist in which SQL clause you would need to place the criteria. a. A store tracks the materials they use in their clothing in a database table. They want to know all materials having an average price of more than $20/sq.yard. b. A company has a log of customer transactions that includes the total price of the merchandise bought in that transaction. A manager wants a list of transactions sorted by these totals from highest to lowest. c. A retail merchandiser has a payroll table that tracks employee hours by store. The manager asks for a number of hours worked, but he wants this information shown by store. d. An oil company has a list of drill sites the company owns in a database table. They want to look at a list of drill sites located in Oklahoma. 3. An elementary school tracks their incoming students in a database. Shown below is the first five records of the student table (there are more records). The school wants to know the average age of the incoming students who are new to the school by the grade they are entering, sorted from lowest to highest grade (0 Kindergarten). Write the SQL query to find that information. Questions: 1. Terminology: For each description below, give the appropriate term to match the description (Hint: Remember terms are bolded in the text). a. There is a table that lists the different stores a retail location operations and different attributes about each store is contained in a column of the table. One of these attributes is location and another lists the date the store was first opened. b. Employees are listed in a payroll database. There is a field that contains numbers that the employees are given upon hire, and no two employees have the same number. c. Someone writes code that will search the database to tell their boss how many deliveries they have made to Hawaii in the past month. d. In a hospital database, there is a patient table, and every line in the table contains information from a patient. e. A firm has a policy that only gives permission to alter or change data already stored in the database. f. A field in a table listing delivery addresses has numbers that uniquely identify which customer is attached to the delivery. 2. SQL Statement: For each description below, ist in which SQL clause you would need to place the criteria. a. A store tracks the materials they use in their clothing in a database table. They want to know all materials having an average price of more than $20/sq.yard. b. A company has a log of customer transactions that includes the total price of the merchandise bought in that transaction. A manager wants a list of transactions sorted by these totals from highest to lowest. c. A retail merchandiser has a payroll table that tracks employee hours by store. The manager asks for a number of hours worked, but he wants this information shown by store. d. An oil company has a list of drill sites the company owns in a database table. They want to look at a list of drill sites located in Oklahoma. 3. An elementary school tracks their incoming students in a database. Shown below is the first five records of the student table (there are more records). The school wants to know the average age of the incoming students who are new to the school by the grade they are entering, sorted from lowest to highest grade (0 Kindergarten). Write the SQL query to find that information