Question: -- Section 1: SQL (90) Part 1: Altering Tables and Modifying Data (40 points) Complete the following table alterations and data modification steps. Provide all

-- Section 1: SQL (90) Part 1: Altering Tables and Modifying Data (40 points) Complete the following table alterations and data modification steps. Provide all SQL executed -- in text form so I can copy and paste your code for testing purposes. I will NOT accept -- screenshots or other images; only text here or in a SQL file. Resetting the Schema -- If you make a mistake and need to start over, right-click on the schema name (i.e., hw3 for -- this assignment) and select "Drop Cascade" and then yes. Download the zipped file -- (hw3.backup.zip) from Canvas in Homework 3 and unzip it. Create a new schema named hw3 -- (right-click on "Schemas", select "Create -> Schema...", "Name" is hw3, "Owner" is postgres). It is vital that the schema be correctly named, or nothing will import. Third, right-click on -- hw3, "Restore...", "Format" is Directory, "Filename" is the path to hw3.backup (the unzipped -- file from the first step), and press "Restore". You may need to refresh the schema to see the new tables (right-click on the schema and select "Refresh")
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
