COIT20248 Information System Analysis and Design- Intelligent Systems
based on the case study provided to you on Moodle:
- Find out all Critical Use Cases
- Draw Context Level diagram.
- Draw Level 0 data flow diagram depicting all the business process description provided.
- Draw ERD showing all required entities and its relationships.
- Draw CRUD diagram.
- Identify and provide all the required data elements you will need for your data entities for the case study provided.
- Provide a prototype of website design and architecture you have developed based on the case study.
Answer:
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.
Buy COIT20248 Information System Analysis and Design- Intelligent Systems Answers Online
Talk to our expert to get the help with COIT20248 Information System Analysis and Design- Intelligent Systems Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
