test
Tables (3)
department
- deptno — char(3) — Primary key — NOT NULL
- dname — nvarchar2(10)
- college — char(3)
- loc — nvarchar2(4)
professor
- profno — char(4) — Primary key — NOT NULL
- name — nvarchar2(5)
- userid — varchar2(10)
- position — nvarchar2(4)
- sal — number(10)
- hiredate — date
- comm — number(3)
- deptno — char(3)
student
- studno — char(5) — Primary key — NOT NULL
- name — nvarchar2(5)
- userid — varchar2(10)
- grade — number(1)
- idnum — char(13)
- birthdate — date
- tel — varchar2(13)
- height — number(5)
- weight — number(5)
- deptno — char(3)
- profno — char(4)