StudentManagement

Tables (10)

Copy Of Grade (CopyOfGrade)

  • sub_Id (Key) — varchar(45) — Primary key — NOT NULL
  • g_s_Id (Key2) — int — Primary key — NOT NULL
  • sub_Id (Key3) — varchar(45) — Foreign key → Copy Of Subject.sub_Id — NOT NULL
  • g_sub_Name (Field) — varchar(45)
  • g_Score (Field2) — int
  • g_Grade (Field3) — varchar(10)

Copy Of Member (CopyOfMember)

  • userId (Key) — int — Primary key — NOT NULL
  • userPwd (Field) — varchar(20)
  • userName (Field2) — varchar(10)
  • userRole (Field3) — varchar(10)

Copy Of Professor (CopyOfProfessor)

  • p_Id (Key) — int — Primary key — NOT NULL
  • p_Name (Field) — varchar(45)
  • p_Birth (Field2) — varchar(45)

Copy Of Student (CopyOfStudent)

  • s_Id (Key) — int — Primary key — NOT NULL
  • s_Name (Field) — varchar(45)
  • s_Birth (Field2) — varchar(45)

Copy Of Subject (CopyOfSubject)

  • sub_Id (Key) — varchar(45) — Primary key — NOT NULL
  • sub_Name (Field) — varchar(45)
  • sub_p_Id (Field2) — int
  • sub_Credit (Field3) — int

Grade

  • g_sub_Id (Key) — varchar(45) — Primary key — NOT NULL
  • g_s_Id (Key2) — int — Primary key — NOT NULL
  • g_sub_Name (Field) — varchar(45)
  • g_Score (Field2) — int
  • g_Grade (Field3) — varchar(10)

Member

  • userId (Key) — int — Primary key — NOT NULL
  • userPwd (Field) — varchar(20)
  • userName (Field2) — varchar(10)
  • userRole (Field3) — varchar(10)

Professor

  • p_Id (Key) — int — Primary key — NOT NULL
  • p_Name (Field) — varchar(45)
  • p_Birth (Field2) — varchar(45)

Student

  • s_Id (Key) — int — Primary key — NOT NULL
  • s_Name (Field) — varchar(45)
  • s_Birth (Field2) — varchar(45)

Subject

  • sub_Id (Key) — varchar(45) — Primary key — NOT NULL
  • sub_Name (Field) — varchar(45)
  • sub_p_Id (Field2) — int
  • sub_Credit (Field3) — int