Advertisement
Guest User

Untitled

a guest
Mar 21st, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. create table department
  2. (deptid number(3) primary key,
  3. dept_name varchar(2) check (dept_name in('CSE','EEE','BBA','Eng','Ach')),
  4. budget number(6)
  5. DEFAULT 0 );
  6. desc department;
  7.  
  8. create table course(crs_id number(4) primary key,
  9. crs_name varchar2(20) not null,
  10. deptid number(3) REFERENCES department (deptid));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement