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

-- 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!