Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL class homework trouble Write the SQL to CREATE a new table in Oracle XE, then INSERT three rows of data into your table. (Use

SQL class homework trouble

Write the SQL to CREATE a new table in Oracle XE, then INSERT three rows of data into your table. (Use yourself as one row of data.) Table name: STUDENT Primary Key: StudentID Other Attributes: Firstname, Lastname, Street, City, State, Zip, Major, GradeLevel, DateofBirth, Gender Once your table has been successfully created in SQL Developer, copy and paste the SQL command used into a Word Document AND the screenshot of your SQL Developer window The screenshot should include the entire SQL Developer window including your database connection. So it would look something like this

Answer #1: CREATE TABLE REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME CHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL_CODE CHAR(5), INSERT INTO ORDER_LINE VALUES ('51623','KD34',10.00,13.10); INSERT INTO ORDER_LINE VALUES ('51625','MT03',8.00,45.79); NOTE: This is an incomplete script to save space. You should always include all of the SQL that is requested

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions

Question

What is Centrifugation?

Answered: 1 week ago

Question

To find integral of ?a 2 - x 2

Answered: 1 week ago

Question

To find integral of e 3x sin4x

Answered: 1 week ago

Question

To find the integral of 3x/(x - 1)(x - 2)(x - 3)

Answered: 1 week ago

Question

What are Fatty acids?

Answered: 1 week ago