Test

Tables (6)

Course

  • Id — Int — Primary key — NOT NULL
  • _name — nchar(30)
  • credit — Int
  • dept_id — Int — NOT NULL
  • prof_id — Int — NOT NULL

Department

  • Id — Int — Primary key — NOT NULL
  • _name — nchar(30)
  • phone — char(13)
  • addr — nchar(50)

Lab

  • Id2 — Int — Foreign key → Professor.Id — NOT NULL
  • _name — nchar(30)

Professor

  • Id — Int — Primary key — NOT NULL
  • _name — nchar(4)
  • phone — char(13)
  • Id (did) — Int — Foreign key → Department.Id — NOT NULL

Student

  • Id — Int — Primary key — NOT NULL
  • _name — nchar(30)
  • birth — datetime2
  • dept_id — Int — NOT NULL
  • Id2 — Int — NOT NULL
  • phone — char(13)

Sugang

  • cid — Int — Foreign key → Course.Id — NOT NULL
  • sid — Int — Foreign key → Student.Id — NOT NULL
  • gpa — char(2)
  • open_year — datetime2
  • open_semister — tinyint