Skip to content
Laravel

Applications Management

Introduction

Application management is a pivotal process in OTAS, initiated when a user creates an application on behalf of a student. The steps involved include selecting an institution, specifying the academic semester and year, and choosing the level of the program. These selections dynamically refine the list of available programs to align with the specified criteria. Once the relevant program is chosen from the updated list, the user can proceed to create the application for the student.

Tables

Applications management

The ERD for application management in OTAS depicts the following relationships and entities:

  • OC_Users: This table contains user data and is involved in multiple relational aspects of an application. Users can be creators, assignees, or have other roles (such as cl1, cl2) that allow multiple users to manage an application through to its completion. This suggests a one-to-many relationship, where each user can be associated with multiple applications in different capacities.

  • Students: This table contains user data and is involved in multiple relational aspects of an application. Users can be creators, assignees, or have other roles (such as cl1, cl2) that allow multiple users to manage an application through to its completion. This suggests a one-to-many relationship, where each user can be associated with multiple applications in different capacities.

  • Institutions: Educational entities that offer programs. There's a relationship indicating that institutions have applications, suggesting that each application is tied to a specific institution.

  • Program: This entity represents the individual academic programs offered by institutions. Programs have a relationship with applications, indicating that each application is for a specific program.

  • Academic Years: Programs are associated with academic years, showing that programs are offered over specific academic periods.

  • Applications: The central entity around which this ERD is structured. Applications have relationships with scholarships, semesters, and levels, indicating that each application can be associated with a particular scholarship, semester, and academic level.

  • Scholarships: This entity suggests that there are different scholarships available, and each application can be linked to a scholarship.

  • Semesters: This entity relates to the time division of academic study. Applications have a relationship with semesters, indicating that each application specifies the semester for which the student is applying.

  • Levels: Likely represents the academic levels or stages, such as Bachelor's, Master's, etc. Applications are associated with levels, meaning that each application is for a specific academic level.

In summary, the ERD outlines how applications are the core component, linked to students, institutions, programs, academic years, scholarships, semesters, and levels, defining a multifaceted relationship structure that supports the application management process in OTAS.