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.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps