university

Tables (7)

classroom

    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

    time_slot