Institutional Placement Data Management System

In academic institutions, placement and recruitment activities are often managed manually using fragmented tools like emails, spreadsheets, and forms. These disjointed systems result in redundancy, communication gaps, and lack of data analytics. The proposed Centralized Training and Placement Portal (TNP Portal) unifies the entire placement workflow by automating job postings, eligibility checks, resume submissions, and reporting. The system uses a three-tier architecture consisting of a Next.js frontend, Node.js + Express backend, and PostgreSQL database with Auth0 Role-Based Access Control (RBAC) for security. This approach ensures efficiency, transparency, and reduced administrative workload, improving overall placement performance and user experience. This research presents the design and implementation of a Centralized Training and Placement Portal (TNP Portal) that unifies the entire placement lifecycle into a single digital system. The portal automates core processes including job posting, eligibility verification, resume management, application tracking, and reporting. User security is ensured through Auth0 authentication with JWT-based Role-Based Access Control (RBAC), providing dedicated modules for Students, TPOs, and Recruiters. Real-time dashboards enable institutions to visualize placement performance, generate reports, and track KPIs such as recruiter participation, application count, and successful hires. Experimental evaluation demonstrated that the system improved processing efficiency by 63%, eliminated duplicate data entries, reduced shortlisting time from hours to seconds, and enabled transparency through end-to-end workflow tracking. The TNP Portal represents a scalable and secure solution that transforms placement management from a fragmented manual process into an automated, data-driven ecosystem.

In most academic institutions, campus recruitment processes are handled manually, involving repetitive tasks, paperwork, and miscommunication between students, recruiters, and Training and Placement Officers (TPOs)[1], [7]. These inefficiencies often lead to data loss, delays, and a lack of transparency. This paper proposes HireLink – a web-based campus recruitment platform, a digital solution designed to automate and streamline the placement process. HireLink offers modules for student registration, job posting, drive management, resume generation, and analytics dashboards, as well as an alumni portal for mentorship and networking. Developed using React.js, Django, and MySQL, the platform ensures scalability, security, and responsiveness. By reducing manual work and enhancing coordination, HireLink is expected to improve efficiency, transparency, and data-driven decision-making in campus recruitment, laying the foundation for a modernized and centralized placement ecosystem[5].

Role based access control (RBAC) is a powerful security administration concept that can simplify permission assignment management. Migration to and maintenance of RBAC requires role engineering, the identification of a set of roles that offer administrative benefit. However, establishing that RBAC is desirable in a given enterprise is lacking in current role engineering processes. To help identify the practical need for RBAC, we propose RoleVAT, a Role engineering tool for the Visual Assessment of user and permission Tendencies. User and permission clusters can be visually identified as potential user groups or roles. The benefit and impact of this visual analysis in enterprise environments is discussed and demonstrated through testing on real life as well as synthetic datasets. Our experimental results show the effectiveness of RoleVAT as well as interesting user and role tendencies in real enterprise environments.

Crab aquaculture has become one of the key sectors in the development of aquaculture in Indonesia, particularly in coastal areas such as Jepara. The Brackishwater Aquaculture Development Center (BBPBAP) Jepara plays a strategic role in advancing aquaculture technology and practices. However, field monitoring activities are still often carried out manually using paper-based records or simple spreadsheets. This practice not only complicates data collection and processing but also increases the risk of data loss and delays in decision-making. This study aims to design and implement a web-based Crab Aquaculture Monitoring Information System at BBPBAP Jepara, utilizing Laravel as the backend framework, Tailwind CSS for a modern and responsive user interface, and MySQL as the database management system. The system is designed to simplify data recording, management, and visualization, thereby supporting BBPBAP Jepara staff and management in conducting comprehensive monitoring. The system development follows the Waterfall methodology, consisting of sequential stages including requirements analysis, system design, implementation, testing, and maintenance. The testing and evaluation results show that the system improves recording efficiency, monitoring accuracy, and user coordination. Features such as reporting, interactive charts, role-based access control, and data export provide added value for analysis and decision-making. Thus, the system makes a tangible contribution to supporting operational transparency and enhancing data management in aquaculture at BBPBAP Jepara.

Since Role-Based Access Control (RBAC) shows great advantage in meeting the security need in large-scale and enterprise-wide system, RBAC becomes the hot topic in access control research field. However, current approaches to access control are mostly based on individual user identity; hence they do not scale to distributed systems. So, the paper analyses RBAC could not satisfy dynamic access control in distributed environment, and puts forward an dynamic access control model based on roles and trust control, giving every trust value for each user by introducing trust management to access control, each role corresponds a certain trust vale, users and systems give values for each other after operation, trust management modesties and updates trust values, users roles will change accordingly, The experiment shows that the model is much validated, and something useful is obtained. The extended model can meet the need to manage and enforce the strong and efficient access control technology in large-scale environments. The flexility and broad application of the proposed model through the system is testified and something useful is obtained.

Access control policies of XML documents are often specified based on user roles and data content of the documents. Content-based authorization is crucial for providing fine-grained access control to data in XML document. Since authorization rules (authorizations, for short) use path expressions of XPath for locating data in documents, authorization definition is related to structure of the document. However, the structure of XML documents tends to change by various reasons such as application extension and information exchange between organizations. Therefore, authorizations must be revised whenever they become incompatible with a new structure of the document. As far as we know, no previous work has discussed the problem of transforming content-based authorizations for XML documents by using schema mapping information. We define classes for schema and document transformations that allow transforming authorizations without access to source and target XML documents. We propose an algorithm that computes authorizations of role-based access control (RBAC) model for a target DTD instance from given RBAC authorizations of a source DTD instance and schema mapping information under the specified classes of schema and document transformations while preserving the authorization policy of the source DTD instance.

Accessing timely and accurate information in academic institutions is often challenging, as students, faculty, and administrators struggle to locate dynamic data such as event schedules, meeting details, and academic notifications, which are typically scattered across multiple systems. Traditional university portals lack intuitive, centralized, and fast query mechanisms, leading to inefficiency, delays, and user dissatisfaction. To address this issue, we present Acadbot, a full-stack web application built using the MERN (MongoDB, Express, React, Node.js) stack, offering a unified and user-friendly dashboard for managing academic information, supported by a secure Role-Based Access Control (RBAC) system that ensures proper authorization for different user groups. The core innovation of this project is its lightweight, database-driven AI chat assistant, which deviates from conventional systems that depend on large vector embeddings, FAISS indexes, and separate retrieval pipelines. Instead, Acadbot employs a practical heuristic-based retrieval engine that performs case-insensitive, token-based, and typo-tolerant regex searches directly on the live MongoDB database. By querying real-time operational data rather than relying on preprocessed vector stores, the system reduces complexity and avoids issues related to outdated or unsynchronized information. This approach enables Acadbot to deliver fast, accurate, and context-aware responses tailored to academic environments. The paper further discusses the system architecture, the implementation of the heuristic retrieval algorithm, and the benefits of adopting this efficient approach for domain-specific academic chatbots. Keywords: MERN Stack, AI Chatbot, Academic Portal, Heuristic Retrieval, Information Retrieval, Role-Based Access Control (RBAC).

Role-based access control (RBAC) is the most predominant access control model in today's security management due to its ability to simplify authorization, and flexibility to specify and enforce protection policies. In RBAC, Separation of Duty (SoD) constrains user role authorization to protect sensitive information from frauds due to conflicts of interests. SoD constraints are commonly defined by mutually exclusive roles (MER) (e.g., bank teller and auditor). This paper proposes practical computational techniques for analyzing SoD by integrating workflows of the enterprise processes into the RBAC framework. Specifically, we present 1) an algorithm for generating MER to enforce SoD, and 2) a verification algorithm to check if a given RBAC state (role authorization and user-role assignments) satisfies a given type of SoD constraint or not. The paper discusses the details of the approach and illustrates its use in a loan application domain.

Access control is generally a rule or procedure that allows, denies, restricts or limit access to system's resources. It may, as well, monitor and record all attempts made to access a system. Access Control may also identify users attempting to access unauthorized resources. It is a mechanism which is very much important for protection in computer security. Various access control models are in use, including the most common Mandatory Access Control (MAC), Discretionary Access Control (DAC) and Role Based Access Control (RBAC). All these models are known as identity based access control models. In all these access control models, user (subjects) and resources (objects) are identified by unique names. Identification may be done directly or through roles assigned to the subjects. These access control methods are effective in unchangeable distributed system, where there are only a set of Users with a known set of services. For this reason, we propose a framework which is well suited to many situations in cloud computing where users or applications can be clearly separated according to their job functions. In this chapter, we proposes a role based access control framework with various features including security of sensitive data, authorization policy and secure data from hackers. Our proposed role based access control algorithm provides tailored and fine level of user access control services without adding complexity, and supports access privileges updates dynamically when a user's role is added or updated.

This study explores the impact of cloud technology implementation on collaboration, data management, and information security within a property development company. Prior to the implementation, the company faced significant challenges, including fragmented data storage, limited cross-team collaboration, and inadequate data security measures. Through a case study approach, this research analyzes the transition from a fragmented system to a centralized cloud infrastructure. The findings indicate that cloud adoption improved real-time collaboration across dispersed teams, reduced data duplication by 30%, and enhanced data security through role-based access control and encryption. Additionally, the centralized data storage system improved the accuracy of project information and sped up decision-making processes by 25%. The research also highlights how cloud technology helped the company meet compliance standards like ISO 27001 while enhancing operational efficiency. This study contributes valuable insights into how cloud solutions can streamline operations in complex industries like property development, emphasizing the need for continuous adaptation of technological solutions to meet evolving business demands.

AI applications of data sharing in agriculture 4.0: A framework for role-based data access control

In today's dynamic networking environment, securing access to resources has become increasingly challenging due to the growth and progress of connected devices. This study explores the integration of Role-Based Access Control (RBAC) and OAuth 2.0 protocols to enhance network access management and security enforcement in an Android mobile application. The study adopts a waterfall methodology to implement access control mechanisms that govern authentication and authorization. OAuth 2.0, a widely adopted open-standard authorization framework, was implemented to secure user authentication by allowing third-party access without exposing user credentials. Meanwhile, RBAC was leveraged to streamline access permissions based on predefined user roles, ensuring that access privileges are granted according to hierarchical role structures. The main outcomes of this study show significance towards the improvements in security enforcement and user access management. Specifically, the implementation of multi-factor authentication, session timeout mechanisms, and user role-based authorization ensured robust protection of sensitive data while maintaining system usability. RBAC proved effective in controlling access to various system resources, such as database operations which was presented in scenario of physical access to doors, while OAuth 2.0 provided a secure communication channel for authentication events. These protocols, working in tandem, addressed key issues like unauthorized access, data integrity, and scalability in network security policy enforcement. This research deduces that combining RBAC and OAuth 2.0 protocols in mobile applications enhances security posture, simplifies access management, and mitigates evolving threats.

Many engineering colleges still use manual methods like paper registers and notice boards for managing attendance and results. This makes things slow and students often do not get information on time. In this paper we present a web- based Student Portal built during our Second Year Engineering project. The system supports four types of users - Student, Faculty, Admin, and Parent - each with their own login and dashboard. We used React.js for the frontend, Node.js and Express.js for the backend, and MongoDB Atlas to store data. Login is secured using JSON Web Tokens (JWT). Access to each dashboard is controlled based on the user role, both on the frontend and the backend. Role separation was confirmed - no user could access another role's data. The system is a simple but working solution to replace paper- based academic management

Most of valuable information resources for all organizations are stored in database. It's a serious subject to protect this information against intruders. However, conventional security mechanisms haven't been designed to detect anomalous actions of database users. Intrusion detection systems (IDS) deliver an extra layer of security that cannot be guaranteed by built-in security tools. IDS provide the ideal solution to defend databases from intruders. In this paper, we suggest an anomaly detection approach that summarizes the raw transactional SQL queries into compact data structure called hexplet, which can model normal database access behavior (abstract the user's role profile) and recognize impostors specifically tailored for role-based access control (RBAC) database system. This hexplet allows us to preserve the correlation among SQL statements in the same transaction by exploiting the information in the transaction-log entry. Our target is to improve detection accuracy, specially the detection of those intruders inside the organization who behave strange behavior. Our model utilizes Naive Bayes Classifier (NBC) as a simple technique for evaluating the legitimacy of transaction. Experimental results show the performance of the proposed model in the term of error equal rate.

Student organizations in higher education institutions play a pivotal role in fostering leadership and collaboration. Despite their importance, many still utilize manual document administration processes, resulting in inefficiencies, delays, and a lack of transparency. This research introduces the design and implementation of a web-based Document Management System integrated with Hierarchical Role-Based Access Control (HRBAC) for student organizations at Universitas Tarumanagara. The system adopts a structured and secure framework tailored to the organization’s approval hierarchy, encompassing roles such as UKM/HIMA, BEM, DPM, Faculty Advisors, Deans, and the Student Affairs Office. Each role is assigned specific access privileges to ensure secure and efficient document submission and approval workflows, aligned with organizational needs. The system was developed using the Laravel framework, PHP, HTML, SCSS, JavaScript, and MySQL, following the Waterfall methodology. Usability was evaluated using the System Usability Scale (SUS), achieving a score of 78.33, categorizing it as “Good” in terms of user experience and navigability. The findings indicate significant improvements in process automation, role-based access control, and document traceability. This research offers a comprehensive model for digital transformation in student organization administration, emphasizing the effectiveness of hierarchical access control in optimizing administrative workflows within academic institutions.