Activity 3: Select Query Attached Files: File Activity03.sql (542 B) Using the sqlda database, create and execute the queries described in the book. Submit a Word document with screenshots from pgadmin4 or any other sql client you might prefer. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Assignment Exercise 6: Select Queries Attached Files: File Exercise06.sql (84 B) Exercise 6: Using the sqlda database, execute the query provided in the book. Pay attention to where single and double quotes are used. Submit a screenshot from pgadmin4 (or any other SQL client that might prefer). Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Assignment Exercise 7: Creating Tables Attached Files: File Exercise07.sql (130 B) Create the countries table using the sqlda database. Alter the products table to add a column called weight. Give it an int datatype. Insert a new scooter into the products table. Submit a Word document with pgadmin screenshots showing the results of the queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Assignment Exercise 8: Updating Tables Attached Files: File Exercise08.sql (275 B) Using the sqlda database, update the Model Chi price as shown in the text. Write a select query to see if the change was made. Submit a Word document with screenshots of the results of the queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Assignment Exercise 9: Deleting a table Attached Files: File Exercise09.sql (186 B) Create a state_populations table, if one does not exist. Using the sqlda database, delete the state_populations table. Write a select query to see what data is still in the state_populations table. Submit a Word document with screenshots from pgadmin4 of the results of the queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Assignment Activity 4: Marketing Queries Attached Files: File Activity04.sql (508 B) Following the instructions in the text and using the sqlda database, create a new customers_nyc table from the customers table. Delete the customers as described, add a new column called event, and make the value 'thank-you party'. Delete the table. Submit a Word document with screenshots of the successful queries. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
