
The objective of this project is to design and develop a secure Customer Relationship Management (CRM) application using Role-Based Data Access Control. The system ensures that customer data is accessed and managed only by authorized users while helping students gain practical experience in secure software development and database management.
Analyze CRM business requirements and prepare Software Requirement Specification (SRS).
Design system architecture focusing on secure data flow and role-based access.
Create database schema for users, roles, permissions, customers, leads, interactions, and sales records.
Implement authentication and role-based data access control (Admin, Sales Manager, Sales Executive roles).
Develop secure login and session management with password hashing.
Build modules for customer data management, lead tracking, and interaction history.
Restrict viewing, editing, and deletion of customer data based on assigned roles.
Implement dashboards and reports according to user roles and access privileges.
Design responsive user interfaces using HTML, CSS, JavaScript, or a frontend framework.
Integrate backend services using Java / Python / PHP / Node.js as per BCA/MCA curriculum.
Apply input validation and secure coding practices to prevent common vulnerabilities.
Maintain activity logs and audit trails for tracking data access and modifications.
Perform unit testing, integration testing, and access-control testing.
Generate reports such as sales performance, customer activity, and lead status.
Prepare project documentation including ER diagrams, DFDs, test cases, and deployment details.