Students Mangment System

Tables (9)

Enrollments Info (Untitled5)

  • ID_Inrollment (Key) — int — Primary key — NOT NULL
  • ID_students (Key2) — int — Foreign key → Students Inforamtion.ID_students — NOT NULL
  • Inrollment_Date (Field) — DateTime
  • Statues (Field2) — Tinyint
  • IS_GroupLeader (Field3) — tinyint
  • Is_representative (Field4) — tinyint

Exam_Info (Untitled6)

  • ID_Exam (Key) — int — Primary key — NOT NULL
  • Exam_Degree (Field) — SmallMoney
  • Exam_Date (Field2) — DateTime

Groups (CopyOfCopyOfUntitled3)

  • ID_Group (Key) — int — Primary key — NOT NULL
  • Level_Group (Field) — nvarchar(20)

Levels (CopyOfUntitled3)

  • ID_Level (Key) — int — Primary key — NOT NULL
  • Level_Name (Field) — nvarchar(20)

Specializations (Untitled3)

  • ID_Specialization (Key) — int — Primary key — NOT NULL
  • Field_Specialization (Field) — nvarchar(20)

Students Inforamtion (Untitled2)

  • ID_students (Key) — int — Primary key — NOT NULL
  • First_Name (Field) — nvarchar(15)
  • Middle_Name (Field2) — nvarchar(15)
  • Third_Name (Field3) — nvarchar(15)
  • Last_Name (Field4) — nvarchar(15)
  • Gender (Field5) — tinyint
  • Phone_Number (Field6) — nvarchar(15)
  • Country_Code (Field7) — nvarchar(5)
  • ID_Specialization (Key2) — int — Foreign key → Specializations.ID_Specialization — NOT NULL
  • ID_Level (Key3) — int — Foreign key → Levels.ID_Level — NOT NULL
  • ID_Group (Key4) — int — Foreign key → Groups.ID_Group — NOT NULL

StudentsInGroups (Untitled4)

  • ID_StGr (Key) — int — Primary key — NOT NULL
  • ID_Group (Key2) — int — Foreign key → Groups.ID_Group — NOT NULL
  • ID_students (Key3) — int — Foreign key → Students Inforamtion.ID_students — NOT NULL

Tists (Untitled7)

  • Tist_ID (Key) — int — Primary key — NOT NULL
  • ID_Exam (Key2) — int — Foreign key → Exam_Info.ID_Exam — NOT NULL
  • ID_students (Key3) — int — Foreign key → Students Inforamtion.ID_students — NOT NULL
  • student_Degree (Field) — int

Users Information (Untitled)

  • ID_User (Key) — int — Primary key — NOT NULL
  • User_Name (Field) — nvarcar(20)
  • Password (Field2)