dd

Tables (5)

COURSE

  • COURSE_ID — INT
  • COURSE_NAME — VARCHAR(100) — NOT NULL
  • DEPT — VARCHAR(50)
  • GRADE — INT
  • CREDIT — INT
  • PROF_ID — INT
  • ROOM_ID — VARCHAR(10)
  • DAY_OF_WEEK — VARCHAR(5)
  • PERIOD — INT
  • CAPACITY — INT
  • CHECK — (CAPACITY >= 1)

ENROLLMENT

  • ENROLL_ID — INT
  • STUDENT_ID — INT — NOT NULL
  • COURSE_ID — INT — NOT NULL
  • REG_DATE — DATE

PROFESSOR

  • PROF_ID — INT
  • NAME — VARCHAR(50) — NOT NULL
  • DEPT — VARCHAR(50)

ROOM

  • ROOM_ID — VARCHAR(10)
  • BUILDING — VARCHAR(50)
  • FLOOR — INT
  • ROOM_NO — VARCHAR(10)

STUDENT

  • STUDENT_ID — INT
  • NAME — VARCHAR(50) — NOT NULL
  • DEPT — VARCHAR(50)
  • GRADE — INT