Create a procedure that builds a denormalized table with the following fields: S

ID: 655235 • Letter: C

Question

Create a procedure that builds a denormalized table with the following fields:

Student Last Name STUDENT - LAST_NAME

Student First Name STUDENT - FIRST_NAME

Course Number SECTION - COURSE_NO

Section Number SECTION - SECTION_NO

Instructor Last Name INSTRUCTOR - LAST_NAME

Instructor First Name INSTRUCTOR - FIRST_NAME

Any additional fields required to implement the surrogate keys specified below

This table should also include surrogate keys to allow rapid sorting by:

Student Last Name, First Name

Course Number, Section Number

Instructor Last Name, First Name

Submit the .SQL file containing the procedure

create or replace procedure cre
begin
create table student(Last_name varchar(20), First_name varchar(20));

create table section(Course_no numeric, section_no numeric);

create table instructor(Last_name varchar(20), First_name varchar(20));

end;

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.