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)
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)