Question: Need to Create an Anonymous block that Creates and Inserts data into the Student, Course and Student/Course composite tables using the Create and Insert commands

Need to Create an Anonymous block that Creates and Inserts data into the Student, Course and Student/Course composite tables using the Create and Insert commands using the table description attached. Show the tables created and populated by the code using the Select and Describe commands. If I can get the first row from each table, I can follow for the rest of each table.

Student Table

Stu_ID Lname Fname Mi Sex Major Home_State

10001 Smith Sam M M Math Tx

10002 Jones Peter A M English Tx

10003 Peters Anne A F English Me

10004 Johnson John J M CompSci Ca

10005 Penders Alton P F Math Ga

10006 Allen Diane J F Geography Minn

10007 Gill Jennifer F CompSci Tx

10008 Johns Roberta F CompSci Tx

10009 Wier Paul M Math Ala

10010 Evans Richard M English Tx

Course Table

Course_ID Section# C_Name C_Description

COSC1300 001 Intro to Comp. First Computer Course

ITSE2309 001 Intro to DB First Database Course

GEOG1791 002 World Geography Second Geography Course

COSC1315 001 Intro to Prog. Second Computer Course

ITSE1345 001 Intro to DB Prog. Second Database Course

ENGL2617 002 English Literature Second English Course

MATH1101 001 Calculus 1 Second Math Course

ENGL1001 001 American Literature First English Course

MATH1011 001 Trig. & Algebra First Math Course

GEOG1010 001 Texas Geography First Geography Course

Student_Course Table

Stu_ID Course_ID Section#

10001 MATH1101 001

10002 ENGL2617 002

10003 ENGL1001 001

10003 ENGL2617 002

10003 GEOG1010 001

10004 COSC1315 001

10005 MATH1101 001

10006 GEOG1010 001

10006 GEOG1791 002

10007 COSC 1315 001

10007 ITSE2309 001

10008 COSC1315 001

10009 ITSE2309 001

10010 ENGL2617 002

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 Databases Questions!

Need to Create an Anonymous block that Inserts rows of data from the student table into a temporary table and uses a loop with a counter to know when to exit. Set the counter equal to the Count of...

database programming using apex oracle Exercise 1 (19) A. Create an anonymous block that returns the number of students in a section. Prompt for section id, Name the file P2. 1.sql. SENTER SECTION...

please answer this by Using Apex Oracle Program database programing. need accurate answer and should use apex oracle. Assignment #2 (4%) Instruction: Include FULL Screenshot that display your code...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Hello, in this problem I only need numbers 16 and 17 finished, and if you see anything else wrong feel free to change. (only change under "// Type your code here") In PHP 3 --> 3. Problem Description...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

INTRODUCTION The purpose of this assignment is to gain more SQL experience using Oracle. In particular, you will get practice creating tables, inserting data into tables, and performing updates and...

Please help with this SQL Oracle lab. At least with part of it. ---------------------------------------------------------------------------------------- Normalization and Creating Tables (For this...

As stated in its annual report, Unik Computer Corporation is an information technology company, developing and marketing hardware, software, solutions, and services. The following trial balance lists...

A horizontal tube having a diameter of 30 cm is maintained at a constant temperature of 204oC and exposed to helium at 3 atm and 93oC. Calculate the heat lost from the tube for a tube length of 10.4...

Provide an example of a corporation that faced tax consequences related to stock dividends or rights issuance. How did these consequences impact their financial decisions?

Your R&D division has just synthesized a material that will superconduct electricity at room temperature; you have given the go ahead to try to produce this material commercially. It will take five...

understand the roles of line managers and human resource managers in managing people

define what is meant by the term human resource management

3. What are your recommendations for coping with the stress that Diane is experiencing? What will you caution her not to do?