univ

Tables (9)

Answer

  • answer_id (Key) — Primary key — NOT NULL
  • quesition_id (Key2) — Foreign key → question.quesition_id — NOT NULL
  • student_id (Key3) — Foreign key → Student.ID — NOT NULL
  • content (Field2)

Change_Dept_History

  • change_id (Key) — Primary key — NOT NULL
  • i_id (Key4) — Foreign key → Instructor.ID — NOT NULL
  • prev_dept (Key2) — Foreign key → Department.dept_name — NOT NULL
  • new_dept (Key3) — Foreign key → Department.dept_name — NOT NULL

Course

  • course_id — Primary key — NOT NULL
  • dept_name (Key) — Foreign key → Department.dept_name — NOT NULL
  • title (Field)
  • credits (Field3)
  • mandatory (Field4)

Department

  • dept_name (Key) — Primary key — NOT NULL
  • building (Field)
  • budget (Field2)

Instructor

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • dept_name (Field2)
  • salary (Field3)

Student

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • dept_name (Key2) — Foreign key → Department.dept_name — NOT NULL
  • tot_cred (Field3)
  • IsForeigner (Field4)

Untitled5

    question (Question)

    • quesition_id (Key) — Primary key — NOT NULL
    • test_id (Key2) — Foreign key → test.test_id — NOT NULL
    • quest_number (Field2)
    • quest_script (Field)

    test (Test)

    • test_id (Key) — Primary key — NOT NULL
    • course_id — Foreign key → Course.course_id — NOT NULL
    • sec_id (Field2)