db
Tables (5)
Course (course)
- id (Key) — char(8) — Primary key — NOT NULL
- name (Field) — nvarchar(30)
Department
- id (Key) — char(8) — Primary key — NOT NULL
- name (Field) — nvarchar(30)
- phone (Field2) — char(11)
Room (room)
- Key — Primary key — NOT NULL
- name (Field2) — nvarchar(30)
Student (student)
- id (Key) — char(8) — Primary key — NOT NULL
- name (Field) — nvarchar(30)
- phone (Field2) — char(11)
- id (Key2) — char(8) — Foreign key → Department.id — NOT NULL
sugang
- Key — Primary key — NOT NULL
- courseid (Key2) — char(8) — Foreign key → Course.id — NOT NULL
- studentid (Key3) — char(8) — Foreign key → Student.id — NOT NULL
- grade (Field) — char(2)
- year (Field2) — datatime2
- roomid (Key4) — Foreign key → Room.Key — NOT NULL