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)