department budget dept name Varchar(20)Varchar(15) Numeric(12,2) building check if budget > 0 instructor id name Varchar(5)Varchar(20) dept_name not null salary Varchar(20 Numeric(8,2) teaches id course idsec id emester Varchar(5) Varchar(8) Varchar(8) year numeric(4,0) varchar(6) course ur credits title Varchar(8) Varchar(50 Varchar(20) dept_name Numeric(2,0) check if credits > 0 section course id sec id semester Varchar(8) Varhar(8) varchar(6numeric(4,0) Varchar(15) Varchar(7) Varchar year building room_number time_slot_id classroom buiding Varchar(15) Varchar(7) capacity Numeric(4,0) student name id Varchar(5) Varchar(20) dept_name Varchar(20) tot_cred Numeric(3,0) Not null takes id course isec id sec_id semester year grade Varchar(5) Varchar(8) Varchar(8) varchar(6) numeric(4,0) Varchar(2) advisor s_id Varchar(5)Varchar(5) i id rere course id prerea id Varchar(8)Varchar(8)