DB_university
Tables (7)
Classroom (classroom)
- Building (building) — varchar(15) — Primary key — NOT NULL
- Room number (room_number) — varchar(20) — Primary key — NOT NULL
- Capacity (capacity) — numeric(4,0)
Course (course)
- Course id (course_id) — varchar(8) — Primary key — NOT NULL
- Dept name (dept_name) — varchar(20) — Foreign key → Department.Dept name — NOT NULL
- Title (title) — varchar(50)
- Credits (credits) — numeric(2,0)
Department (department)
- Dept name (dept_name) — varchar(20) — Primary key — NOT NULL
- Building (building) — varchar(15)
- Budget (budget) — nemeric(12,2)
Instructor (instructor)
- ID — varchar(5) — Primary key — NOT NULL
- Dept name (dept_name) — varchar(20) — Foreign key → Department.Dept name — NOT NULL
- Name (name) — varchar(20)
- Salary (salary) — numeric(8,2)
Section (section)
- Course id (course_id) — varchar(8) — Primary key — NOT NULL
- Sec id (sec_id) — varchar(8) — Primary key — NOT NULL
- Semester (semester) — varchar(8) — Primary key — NOT NULL
- Year (year) — numeric(4,0) — Primary key — NOT NULL
- Building (building) — varchar(15) — Foreign key → Classroom.Building — NOT NULL
- Room number (room_number) — varchar(20) — Foreign key → Classroom.Room number — NOT NULL
- Time Slot id (time_slot_id) — varchar(4)
Student (student)
- ID — varchar(5) — Primary key — NOT NULL
- Name (name) — varchar(20)
- Total Credit (tot_cred) — numeric(3,0)
Teaches (teaches)
- ID — varchar(5) — Primary key — NOT NULL
- Course ID (course_id) — varchar(8) — Primary key
- Sec ID (sec_id) — varchar(8) — Primary key
- Semester (semester) — varchar(6) — Primary key
- Year (year) — numeric(4,0) — Primary key
- Course id (course_id2) — varchar(8) — Foreign key → Section.Course id — NOT NULL
- Sec id (sec_id2) — varchar(8) — Foreign key → Section.Sec id — NOT NULL
- Semester (semester2) — varchar(8) — Foreign key → Section.Semester — NOT NULL
- Year (year2) — numeric(4,0) — Foreign key → Section.Year — NOT NULL
- Building (building) — varchar(15) — Foreign key → Section.Building — NOT NULL
- Room number (room_number) — varchar(20) — Foreign key → Section.Room number — NOT NULL