Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table department
- (deptid number(3) primary key,
- dept_name varchar(2) check (dept_name in('CSE','EEE','BBA','Eng','Ach')),
- budget number(6)
- DEFAULT 0 );
- desc department;
- create table course(crs_id number(4) primary key,
- crs_name varchar2(20) not null,
- deptid number(3) REFERENCES department (deptid));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement