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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started