university
Tables (7)
course
- course_id — Primary key — NOT NULL
- title
- Field
- depart_name — Foreign key → department.depart_name — NOT NULL
department
- depart_name — Primary key — NOT NULL
- buiing (building)
- Field (budget)
section
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key3 — Primary key — NOT NULL
- ID — Foreign key → takes.course_id — NOT NULL
- course_id — Foreign key → course.course_id — NOT NULL
- Field
student
- ID — Primary key — NOT NULL
- name
- tot_cred
- depart_name — Foreign key → department.depart_name — NOT NULL
takes
- course_id (ID) — Primary key — NOT NULL
- course_id
- sec_id