CRUD Table
|
Entity
|
Student
|
Agent
|
|
Process
|
|
Lodge application
|
CRUD
|
CRUD
|
|
Upload Document
|
CRUD
|
CRUD
|
|
Check Status
|
R
|
R
|
|
Make Payment
|
CRU
|
R
|
|
Enroll
|
CRU
|
R
|
|
Update Details
|
R
|
R
|
Data Element
Student Table
|
No.
|
Column Name
|
Data Type
|
Size
|
|
1.
|
Student ID
|
Number
|
20
|
|
2.
|
Name
|
Text
|
50
|
|
3.
|
Address
|
Varchar2
|
100
|
|
4.
|
Contact No
|
Number
|
10
|
|
5.
|
Qualification
|
Varchar2
|
50
|
Agent Table
|
No.
|
Column Name
|
Data Type
|
Size
|
|
1.
|
Agent ID
|
Number
|
20
|
|
2.
|
Name
|
Text
|
50
|
|
3.
|
Address
|
Varchar2
|
100
|
|
4.
|
Contact No
|
Number
|
10
|
|
5.
|
username
|
Varchar2
|
50
|
|
6.
|
Password
|
Varchar2
|
20
|
Staff Table
|
No.
|
Column Name
|
Data Type
|
Size
|
|
1.
|
Staff ID
|
Number
|
10
|
|
2.
|
Name
|
Text
|
100
|
|
3.
|
Address
|
Varchar2
|
200
|
|
4.
|
Contact No
|
Number
|
10
|
|
5.
|
username
|
Varchar2
|
10
|
|
6.
|
Password
|
Varchar2
|
10
|
Application Table
|
No.
|
Column Name
|
Data Type
|
Size
|
Constraints
|
|
1.
|
Application ID
|
Number
|
10
|
Primary Key
|
|
2.
|
Student ID
|
Number
|
10
|
Foreign Key
|
|
3.
|
Agent ID
|
Number
|
10
|
Foreign Key
|
|
4.
|
Staff ID
|
Number
|
10
|
Foreign Key
|
Payment Table
|
No.
|
Column Name
|
Data Type
|
Size
|
Constraints
|
|
1.
|
Payment ID
|
Number
|
10
|
Primary Key
|
|
2.
|
Student ID
|
Number
|
10
|
Foreign Key
|
|
3.
|
Application ID
|
Number
|
10
|
Foreign Key
|
Enroll Table
|
No.
|
Column Name
|
Data Type
|
Size
|
Constraints
|
|
1.
|
Enroll ID
|
Number
|
10
|
Primary Key
|
|
2.
|
Student ID
|
Number
|
10
|
Foreign Key
|
|
3.
|
Application ID
|
Number
|
10
|
Foreign Key
|
|
4.
|
Payment ID
|
Number
|
10
|
Foreign Key
|
Commission Table
|
No.
|
Column Name
|
Data Type
|
Size
|
Constraints
|
|
1.
|
Commission ID
|
Number
|
20
|
Primary Key
|
|
2.
|
Payment ID
|
Number
|
20
|
Foreign Key
|
|
3.
|
Agent ID
|
Number
|
20
|
Foreign Key
|
Bibliography
Al-alshuhai, A. and Siewe, F., 2015, November. An extension of the use case diagram to model context-aware applications. In SAI Intelligent Systems Conference (IntelliSys), 2015 (pp. 884-888). IEEE.
Clarke, D.L., 2014. Models in archaeology (Vol. 14). Routledge.
Hsu, I.C., Ting, D.H. and Hsueh, N.L., 2014. MDA-based visual modeling approach for resources link relationships using UML profile. Computer Standards & Interfaces, 36(3), pp.648-656.
Khurana, N., Chhillar, R.S. and Chhillar, U., 2016. A Novel Technique for Generation and Optimization of Test Cases Using Use Case, Sequence, Activity Diagram and Genetic Algorithm. JSW, 11(3), pp.242-250.
Nugroho, A. and Chaudron, M.R., 2014. The impact of UML modeling on defect density and defect resolution time in a proprietary system. Empirical Software Engineering, 19(4), pp.926-954.
Seidl, M., Scholz, M., Huemer, C. and Kappel, G., 2015. The Use Case Diagram. In [email protected] Classroom (pp. 23-47). Springer International Publishing.
