-
Notifications
You must be signed in to change notification settings - Fork 9
/
TrainingInstituteManagement.txt
174 lines (142 loc) · 3.31 KB
/
TrainingInstituteManagement.txt
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
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
DB: TrainingInstituteManagment
Students
--------
1. student_id - auto increment, primary key
2. first name
4. last name
5. mob
6. email id
7. gender
8. experince
9. course
10. availability
11. mode
12. date
Course
------
1. course id -auto increment, primary key
2. course name
3. duration
4. fee
5. course desc
6. credits
7. date
Trainer
-------
1. trainer id -auto increment, primary key
2. trainer name
3. experince
4. skillset
5. availability
6. date
Registraction
-------------
1. registration id - auto increment, primary key
2. student_id -FK
3. course id -FK
4. trainer id - FK
5. course start date
6. course end date
7. weekdays_weekend
8. Batch time
9. status
10. course fee
11. date
Controller
----------
1. StudentsController
2. CourseController
3. TrainerController
4. RegistractionController
Service
------
1. TrainingService
DAO
----
1. StudentsDAO
2. CourseDAO
3. TrainerDAO
4. RegistractionDAO
Model
-----
1. Student
2. Course
3. Trainer
4. Registraction
com.tim.controller
com.tim.model
com.tim.service
com.tim.dao
com.tim.daoimpl
DB Connection
==========================================================================================
create database TIM;
use TIM;
CREATE TABLE TIM.Student(
student_id INTEGER NOT NULL AUTO_INCREMENT,
first_name VARCHAR(50),
last_name VARCHAR(50),
mobile VARCHAR(10),
email_id VARCHAR(30),
gender CHAR(1),
experince VARCHAR(15),
course VARCHAR(30),
availability VARCHAR(10),
mode VARCHAR(10),
date DATE,
PRIMARY KEY(student_id));
CREATE TABLE TIM.Course(
course_id INTEGER NOT NULL AUTO_INCREMENT,
course_name VARCHAR(30),
duration VARCHAR(30),
fee FLOAT,
course_desc VARCHAR(50),
credits VARCHAR(20),
date DATE,
PRIMARY KEY(course_id));
CREATE TABLE TIM.Trainer(
trainer_id INTEGER NOT NULL AUTO_INCREMENT,
trainer_name VARCHAR(30),
experience VARCHAR(15),
skillset VARCHAR(50),
availability VARCHAR(10),
date DATE,
PRIMARY KEY(trainer_id));
CREATE TABLE TIM.Registration(
registration_id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
student_id INTEGER,
course_id INTEGER,
trainer_id INTEGER,
course_start_date DATE,
course_end_date DATE,
weekdays_weekend VARCHAR(10),
Batch_time VARCHAR(10),
status VARCHAR(10),
course_fee FLOAT,
date DATE,
CONSTRAINT fk_student_id FOREIGN KEY (student_id) REFERENCES Student(student_id),
CONSTRAINT fk_course_id FOREIGN KEY (course_id) REFERENCES Course(course_id),
CONSTRAINT fk_trainer_id FOREIGN KEY (trainer_id) REFERENCES Trainer(trainer_id));
BugTracking
------------
CREATE TABLE APPLICATION_TBL(
application_id INTEGER NOT NULL AUTO_INCREMENT,
description VARCHAR(30),
application_name VARCHAR(15),
owner VARCHAR(50),
PRIMARY KEY(application_id));
CREATE TABLE RELEASE_TBL(
release_id INTEGER NOT NULL AUTO_INCREMENT,
description VARCHAR(30),
release_date DATE,
PRIMARY KEY(release_id));
CREATE TABLE TICKET_TBL(
ticket_id INTEGER NOT NULL AUTO_INCREMENT,
application_id INTEGER (10),
release_id INTEGER(10),
description VARCHAR(30),
status VARCHAR(15),
title VARCHAR(50),
PRIMARY KEY(ticket_id)
CONSTRAINT fk_application_id FOREIGN KEY (application_id) REFERENCES APPLICATION_TBL(application_id),
CONSTRAINT fk_release_id FOREIGN KEY (release_id) REFERENCES RELEASE_TBL(release_id));