Question 1 Create a scenario from your own experience that requires at least one input validation, one loop for repetition that not related to the input validation and one decision that is not related to the input validation or the loop Status: Not Completed Question 2 Create a flowchart to design a solution for your scenario (note: No Python code required.) Status: Not Completed Question 3 Provide a flowchart for an application (must be different from the scenario provided in part 1) that includes at least one input validation, one loop for repetition that is not related to the input validation and one decision that is not related to the input validation or the loop Status: Not Completed Question 4 Using the File Window in IDLE, create the Python code that implements the flowchart provided in part 3. Include two screen shots: 1 for the code and 1 for the results in the IDLE window.

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: If a GROUP BY clause is included in a SQL query, the characteristics that may be sought in the…

A: Introduction: The Aggregate BY clause in SQL is used to group the results of a SELECT operation on a…

Q: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: To complete the `SELECT` statement to select the year and the average price of books for that year,…

Q: In cell B10, use a SUMIF formula to calculate the sum of AnnualSales where the value in the Regions…

A: Please refer below for your reference: The B9 value consists of region as NE1 In cell B10 write…

Q: Report the name of the customer who bought the most expensive product. sql

A: According to the information given:- We have to write query  in order to get the name of the…

Q: Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code?

A: SQL QUERY:  Select SUM(CUS_BALANCCE) AS [Sum of Balance] From Customer  Group by CUS_CODE.

Q: The WHERE statement identifies the. Sort None of these Filter All of these Table Fields

A: The WHERE statement identifies the

Q: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database,  SELECT statement are used. The data is saved in a result table…

Q: What is the best way to create a basic condition?

A: The question is to write the way to create the basic condition. As it is related to computer science…

Q: List the job title and maximum salary which the salaries are between $10,000 and $20,000. Use…

A: The objective of the question is to retrieve the job title and maximum salary from a database where…

Q: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: The question is asking for a SQL query that will return each genre and the total number of books in…

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

Q: In how many ways can a 16-person club select a president, vice-president, and secretary from among…

A: There are 16 people to choose.in that 3 distinct persons to be selected.

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: In SQL, the WHERE clause to the SELECT statement states the criteria that must be met: Multiple…

A: EXPLANATION: SQL is a database language that allows you to store, manipulate, and retrieve data.…

Q: Answer the remaining questions and please include what number is it

A: In this question we will write a python code for the given description, I will try to implement…

Q: Find the service ID and property ID for each service request whose estimated hours is greater than…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: File Name: Surname_MP8.m Problem Statement: Based on an automobile's model year and weight the state…

A: ANSWER;-

Q: Name the Hourly Rate and Hours Worked arrays. Calculate the total cost of labour using SumProduct.…

A: SUMPRODUCT - This function in excel is used to multiply numerical type arrays together and returns…

Q: Determine the kind of books in the library's current collection. Each category should include just a…

A: Determine the kind of books in the library's current collection. Each category should include just a…

Q: Write the SQL query to find all the place whose temperature is 38. SELECT place WHERE temperature…

A:

Q: department name information for those departments whose location_id is 1500

A: Attributes of Department Table are- department_id department_name employee_id location_id

Q: Rank Normal forms where each form is a subset of the form above it. [ Select) [Select First Normal…

A: We are going to arrange Normal forms in the database.

Q: Which operator should you employ in order to locate NULL values?

A: IS NULL operator is used to locate NULL values

Q: Display the PID and average prices from the PRODUCTS table which price is less than the average…

A: Here we need to perform group by operation in the main query and use Having clause to select only…

Q: Q9) find the least expensive price Q10) List the UNIQUE v_code of vendors that provide products Q11)…

A: A relational database contains tables. Tables are also known as relations and they contain tuples…

Q: Find out what kind of books are currently accessible in the library's collection. Each category…

A: Duplicate records are removed from the result set using the DISTINCT clause. FROM TABLES,  SELECT…

Q: Which clause of a SQL Select statement is required if we want to display aggregate data by category…

A: Answer: 5) GROUP BY

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: Select number of movies grouped by year USING MySQL   The Movie table has the following columns:…

A: Answer: Given table name is Movie Select statement is used to print the required fields on the…

Q: To locate NULL values, which operator should you use?

A: An operator is a special symbol in an SQL statements' WHERE clause which performs operations on…

Q: How can you concatenate columns in a query?

A: To concatenate the columns in a query.   In the SQL,   You can concatenate two or more columns in a…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student  your query get the error because inv_number exist in the two table so you have to…

Q: Determine which categories are covered by the existing book stock. There should only be one listing…

A: A trader's book contains a record of all of the positions that they have taken. The entire number of…

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: column name

A: We need to select Which column name is valid? We've to Select one from: a. NUMBER_1$ b. NUMBER c.…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Determine the kind of books in the library's current collection. Each category should include just a…

A: The question has been answered in step2

Q: ery: List the IDs of the tutors who are currently tutoring more t

A: From the question, we need to write a Query of the list of the IDs of the tutors. SQL that would…

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…