FLOWCHARTING OBJECTIVE In this assignment, students will develop their flowcharting skills on a couple of exercises. In doing so, students will learn how to think logically about a problem to create a process for use in its resolution. ASSIGNMENT Draw each of the following 2 flowcharts. You can use MS Word, MS Powerpoint, Flowchart Software (such as Creately) or simply hand-draw each chart (take a picture or scan both flowcharts then paste them both into one MS Word document). Include your diagrams in the submission via Canvas. Be sure that your diagrams are legible (i.e. that I can read everything and that it is clear whether something is a rectangle, parallelogram, or diamond). DO NOT SUBMIT MULTIPLE DOCUMENTS. Organize your submission in accordance with the numbering given below. Be sure the information in your document is presented clearly and unambiguously. Also, include your name on your document (within the content of the document itself). Hint: Be sure to consider whether there are implied inputs and outputs in each of these processes and whether a given step might constitute an input or output. 1. Create a flowchart that maps the following process, then include it in your submission (50 points): Hint: you are the one doing the processing. a. You hear a noise in the basement. b. You go down to the basement to see if everything is okay, as determined by the number of mice that you see. c. If you see more than 10 mice, you leave the house immediately because that is just too many mice (thus the process ends). d. If you see 0 mice, you go upstairs because, other than the fact that you are imagining basement noises, everything is obviously totally okay (the process ends). e. If you see any other number of mice, you blow your whistle to frighten them away, then go back upstairs, wait ten minutes, then go back down to the basement to see how many mice there are i. Continue blowing your whistle, running upstairs, waiting, then going back down to the basement until there are either 0 or more than 10 mice. 2. Create a flowchart that maps the following process, then include it in your submission (50 points): Hint: you are the one doing the processing. a. You are doing an assignment in which you are expected to write a number of SQL queries. b. You read the prompt for the first requested problem. c. You then input into SQL Server Management Studio a query that you think will provide the output requested. d. You execute the query and receive output from SQL Server. e. If the query coincides with the output requested, continue on to the next problem. f. If the query does not coincide with the output requested, go back and try the same query again. g. Use a variable to count how many queries you have entered correctly. h. Continue the process until all queries are completed successfully. i. Once all queries are written successfully, scream out the window the number of queries you inputted so that everyone (within earshot) knows