Course Solutions Uncategorized (Solved) : Help Database Problem University Database Code Drop Table Prereq Drop Table Timeslot Drop Q26181143 . . . .

(Solved) : Help Database Problem University Database Code Drop Table Prereq Drop Table Timeslot Drop Q26181143 . . . .

 

help with this database problem!

Using the University database, create a trigger that generates a tuple per student to a temporary table with the necessary information, as long as the average of a students grades in a semester is D or less.

University database code:

drop table prereq;

drop table time_slot;

drop table advisor;  

drop table takes;

drop table student;

drop table teaches;

drop table section;  

drop table instructor;

drop table course;

drop table department;

drop table classroom;

create table classroom

(building varchar(15),

room_number varchar(7),

capacity numeric(4,0),

primary key (building, room_number)

);

create table department

(dept_name varchar(20),  

building varchar(15),  

budget numeric(12,2) check (budget > 0),

primary key (dept_name)

);

create table course

(course_id varchar(8),  

title varchar(50),  

dept_name varchar(20),

credits numeric(2,0) check (credits > 0),

primary key (course_id),

foreign

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post