Joe, one of your systems analysis team members, made the following entry for the data dictionary used by Marilyn’s Tours: DATA ELEMENT = TOURIST* * * * PAYMENT ALIAS = TOURIST PAY CHARACTERS = 12−24 RANGE = $5.00−$1,000 VARIABLES = $5.00, $10.00, $15.00, up to $1,000, and anything in between in dollars and cents. TO CALCULATE = TOTAL COST OF ALL TOURS, ANY APPLICABLE NY STATE TAX, minus any RESERVATION DEPOSITS made. a. Is this truly a data element? Why or why not? b. Rewrite the data dictionary entry for TOURIST PAYMENT, reclassifying it if necessary. Use the proper form for the classification you choose.

Question 5 Assume you are given a dictionary student_dict with Mary taking ACT101, FIN202, MIS310 and MIS340, Steve is enrolled in FIN202, MKT300 and MIS310, and Paul is registered for ACT101 and MKT300. With Ist initially set to an empty list, which of the following would complete the code that will correctly produce the list of students taking MIS courses. for key in student_dict: for val in student_dict [key]: if 'MIS' in 1st.append( and O val; val; 1st; key O val; val; 1st; val O val; key; 1st; val O val; key; 1st; key Question 6 0.5 pts not in 0.5 pts Given the customer reviews shown below, which one of the following would correctly display the first company's name XYZ, Inc.? + 100% O KH

Question 6 To get all the variables named x1 through x15 (out of 30 variables that start with x) from data, you could use O filter(data starts with("x")) select(flights."x") Oselect(data.num_range("x"1:15) Opick(flights.starts with("x")) Question 7 To reverse sort the nycflights13::flights data set by month and then by day, you would use O sort values(flights.day.month.descending-TRUE) O filter(flights.desc(month).desc(day)) O filter(flights.desc(day).desc(month)) Osort values(flights,month.day.ascending FALSE) Question 8 To get all the variables from the flights like "arr_delay" and "dep_delay", you could use O filter(flights,ends_with("_delay")) O select(flights.""_delay") O select(flights,ends_with("_delay")) Opick(flights,ends_with("_delay"))

How do you index a CLOB datatype for faster search operations?

MySQL CREATE TABLE students (  id INT PRIMARY KEY,  first_name VARCHAR(50),  last_name VARCHAR(50),  age INT,  major VARCHAR(50),  faculty VARCHAR(50)); CREATE TABLE location (  id INT PRIMARY KEY,  name VARCHAR(50),  rooms INT); CREATE TABLE faculty (  id INT PRIMARY KEY,  name VARCHAR(50),  department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…

individual characters using their 0-based index. Hint: You will need to do this for checking all the rules. However, when you access a character .