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