Create your first script file with the CREATE TABLE commands for each table. a. Build your script in Notepad. b. Correct your code and repeat until you know that each command is correct. c.Using the scripting instructions provided at the beginning of this document as an example, build the following Location table as shown in the diagram below [1]In the first script, build the table structure, including a primary key [2]You should not type in the data records in for this script. c. Save this file on your flash drive in the CSC239 LabAssignments folder with a name of: Lab11_first_script_file.sql d. Paste a copy of the entire script into your Word document.(Do Not screen print the script.) e. To execute the script file in the SQL Command Window: [1]. If you are already logged into Application Express, go back to the main (first level) web page. [2].If not, using a web browser, go to the website: academy.oracle.com [3].Select the “Sign In / Register” option. [4].Select the Application Express option to log in [5]Log into Application Express. [6].Select the “SQL Workshop” button. [7].Select the “SQL Scripts” button. [8].Click on the “Upload” button. [9].Click on the “Browse” button. [10].Select the Script file name you wish to upload from your flash drive. [11].If prompted, add a script name similar to the name of the file you uploaded. [12].Leave the “File Character Set” as the default (Unicode UTF-8). [13].Click on the “Upload” button. [14].You should now see the Script listed. [15].Click the “Run” icon. [16].Click the “Run Now” button. [17].This will take you to the Manage Script Results Page. [18].Click the “View Results” option. [19].If you added any DROP statements into your Script, if the tables do not exist yet, then the DROP statement commands will generate error messages since there were no tables to drop. [20].Click the “SQL Workshop” tab. [21].Click the “Object Browser” button. [22].You should now see the tables listed on the left side of the Object Browser page. [23].You can now open, view and print the table and it’scontents, structure, etc. when needed. f.Do a screen print displaying the results of the script’s execution demonstrating that it ran successfully. g. Copy and paste the table structure built into your Word document. Please help me with these problems. Can you please do it step by step with screenprints and answers so I can know what to do. I am a visual learner so I need help with this.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
Create your first script file with the CREATE TABLE commands for each table. a. Build your script in Notepad. b. Correct your code and repeat until you know that each command is correct. c.Using the scripting instructions provided at the beginning of this document as an example, build the following Location table as shown in the diagram below [1]In the first script, build the table structure, including a primary key [2]You should not type in the data records in for this script. c. Save this file on your flash drive in the CSC239 LabAssignments folder with a name of: Lab11_first_script_file.sql d. Paste a copy of the entire script into your Word document.(Do Not screen print the script.) e. To execute the script file in the SQL Command Window: [1]. If you are already logged into Application Express, go back to the main (first level) web page. [2].If not, using a web browser, go to the website: academy.oracle.com [3].Select the “Sign In / Register” option. [4].Select the Application Express option to log in [5]Log into Application Express. [6].Select the “SQL Workshop” button. [7].Select the “SQL Scripts” button. [8].Click on the “Upload” button. [9].Click on the “Browse” button. [10].Select the Script file name you wish to upload from your flash drive. [11].If prompted, add a script name similar to the name of the file you uploaded. [12].Leave the “File Character Set” as the default (Unicode UTF-8). [13].Click on the “Upload” button. [14].You should now see the Script listed. [15].Click the “Run” icon. [16].Click the “Run Now” button. [17].This will take you to the Manage Script Results Page. [18].Click the “View Results” option. [19].If you added any DROP statements into your Script, if the tables do not exist yet, then the DROP statement commands will generate error messages since there were no tables to drop. [20].Click the “SQL Workshop” tab. [21].Click the “Object Browser” button. [22].You should now see the tables listed on the left side of the Object Browser page. [23].You can now open, view and print the table and it’scontents, structure, etc. when needed. f.Do a screen print displaying the results of the script’s execution demonstrating that it ran successfully. g. Copy and paste the table structure built into your Word document. Please help me with these problems. Can you please do it step by step with screenprints and answers so I can know what to do. I am a visual learner so I need help with this.
Location
LocationID
L01
L02
L03
L04
LO5
L06
L07
L08
L09
L10
L11
L12
Location
White Plains
Boston
Pittsburgh
Edison
New York
San Francisco
Jersey City
Miami
Jacksonville
Orlando
Los Angeles
Cambridge
State
NY
ΜΑ
PA
NJ
NY
CA
NJ
FL
FL
FL
CA
MA
Zipcode
02190
15219
12345
10029
94102
67890
33018
32801
90210
Transcribed Image Text:Location LocationID L01 L02 L03 L04 LO5 L06 L07 L08 L09 L10 L11 L12 Location White Plains Boston Pittsburgh Edison New York San Francisco Jersey City Miami Jacksonville Orlando Los Angeles Cambridge State NY ΜΑ PA NJ NY CA NJ FL FL FL CA MA Zipcode 02190 15219 12345 10029 94102 67890 33018 32801 90210
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education