Assignment 3 BUSA 326 Data and Information Management Fall 2023 Instructor: Prof. Brodnax Assignment: Please post the
Question:
Assignment 3 BUSA 326 Data and Information Management Fall 2023 Instructor: Prof. Brodnax Assignment: Please post the following in the class dropbox NLT 11:00 pm, 10 Oct. Create one .sql file with SQL queries that executes the requirement noted below. Make sure you have comments in your sql in the beginning providing your name, course/course section, and CWID. (points deducted for not having this comment) 1. Use the salesordersDB database schema. 2. Translate the requirement below into a SQL query that accomplishes the following: -a. “Management wants to see all current products with an inventory value of $1200.00 or more”. Make sure it looks exactly like the example output (at the back of this assignment). Hint: 20 rows returned. 3. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 4. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirements that are provided in the output grid. 5. As noted above, post the SQL (sql) file that executes the required query. The sql file (only 1 file submitted) must be posted in the dropbox by the due date to receive full credit. 6. Outputs for each requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below. Note: Required output noted below may not have all rows shown.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill