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)