SMS_DB/Data_Add_Query.sql at master · mdnazrulislambd/SMS_DB · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
-- Classes
INSERT INTO Classes (ClassName, Description)
VALUES

-- Sections
INSERT INTO Sections (SectionName, ClassID)
VALUES

-- Subjects
INSERT INTO Subjects (SubjectName)
VALUES

-- Teachers
INSERT INTO Teachers (FullName, Gender, Qualification, Department, Phone)
VALUES

-- ClassSubjects
INSERT INTO ClassSubjects
VALUES

-- TeacherSubjects
INSERT INTO TeacherSubjects
VALUES

-- Students
INSERT INTO Students (RollNo, FullName, Gender, DateOfBirth, ClassID, SectionID, Address, Phone)
VALUES

-- ExamTypes
INSERT INTO ExamTypes (ExamTypeName, Description)
VALUES

-- Exams
INSERT INTO Exams (ExamTypeID, ClassID, SectionID, ExamName, ExamStartDate, ExamEndDate)
VALUES

-- ExamSubjects
INSERT INTO ExamSubjects (ExamID, SubjectID, ExamDate, FullMarks, PassMarks)
VALUES

-- StudentMarks
INSERT INTO StudentMarks (StudentID, ExamID, SubjectID, ObtainedMarks)
VALUES

-- Grades
INSERT INTO Grades (GradeName, MinMarks, MaxMarks, GPA)
VALUES

-- Attendance
INSERT INTO Attendance (StudentID, Date, Status)
VALUES

-- ClassRoutine
INSERT INTO ClassRoutine (ClassID, SectionID, SubjectID, TeacherID, DayOfWeek, StartTime, EndTime)
VALUES

-- Fees
INSERT INTO Fees (FeeType, Description, Amount)
VALUES

-- StudentFees
INSERT INTO StudentFees (StudentID, FeeID, AmountPaid, DueAmount)
VALUES

-- Designations
INSERT INTO Designations (DesignationName)
VALUES

-- Departments
INSERT INTO Departments (DepartmentName)
VALUES

-- Transport
INSERT INTO Transport (VehicleNo, DriverName, Capacity)
VALUES

-- Routes
INSERT INTO Routes (RouteName, TransportID)
VALUES

-- BusStudents
INSERT INTO BusStudents (StudentID, RouteID)
VALUES

-- Hostels
INSERT INTO Hostels (HostelName, Location)
VALUES

-- HostelRooms
INSERT INTO HostelRooms (HostelID, RoomNo, Capacity)
VALUES

-- StudentHostel
INSERT INTO StudentHostel (StudentID, RoomID)
VALUES

-- Roles
INSERT INTO Roles (RoleName)
VALUES

-- Users
INSERT INTO Users (UserName, PasswordHash, FullName, RoleID)
VALUES

-- Staffs
INSERT INTO Staffs (FullName, Gender, DateOfBirth, HireDate, DesignationID, DepartmentID, Phone, Email)
VALUES

-- Parents
INSERT INTO Parents (ParentName, Gender, Phone, Address, Email)
VALUES

-- StudentParent
INSERT INTO StudentParent (StudentID, ParentID, Relation)
VALUES

-- BookCategories
INSERT INTO BookCategories (CategoryName, Description)
VALUES

-- LibraryBooks
INSERT INTO LibraryBooks (Title, Author, ISBN, PublishedYear, CategoryID, Quantity, AvailableCopies)
VALUES

-- BookIssues
INSERT INTO BookIssues (BookID, StudentID, IssueDate, DueDate)
VALUES

-- Periods
INSERT INTO Periods (PeriodName, StartTime, EndTime)
VALUES

-- Notices
INSERT INTO Notices (Title, Description, CreatedBy, ExpiryDate)
VALUES

-- Events
INSERT INTO Events (EventTitle, EventDate, Location, Description, CreatedBy)
VALUES

-- UserRoles
INSERT INTO UserRoles (UserID, RoleID)
VALUES