AlgoBulls: Business Database Management System

Domains: Database Management, Software Development
Partner: AlgoBulls
Description: The objective of this project is to design and implement a database management system for managing business operations for a financial services firm. Tasks include database schema design, user access control, statistical analysis and general web deployment tasks. The application will have a backend built with Django, a frontend using React, and will include features like role-based access control, Excel sheet-based data loading, and interactive dashboards for data analysis.

Roles: 1 database developer
Stipend: Paid project
Project Duration: 1 month
Tasks/Deliverables:

• Database setup with PostgreSQL or MySQL
• Frontend components using React for user interface
• Backend API development for CRUD operations and data retrieval
• Implementation of role-based access control and two-factor authentication
• Integration of frontend and backend systems
• Testing, bug fixes, and deployment of the application
• Documentation for system usage and maintenance

Submission Link: https://forms.gle/sAFyxHre8yRcwS8R7
Deadline: 5:00 PM, 30th March, 2024
To enroll for the project, you must fill out the form above. For further credit, you can attempt and submit the assignment below to the best of your abilities, taking the aid of any tools online. We will contact you personally if you are shortlisted for the interview.

(Optional) Assignment:

This assignment is to design a database system with multiple hierarchical levels and implement permission controls within a Django application. The application will allow users to manage data according to their hierarchical positions, with different levels of access and control.

Design a database schema with at least three levels of hierarchy: 

• Superuser
• Intermediate level (seniors)
• Lowest level (junior members)

Tasks:

1. Design a database schema with tables for users, hierarchical levels, and data entries
2. Define relationships between the tables to represent the hierarchical structure
3. Implement user authentication using Django's built-in authentication system and set up Django-admin for superuser management
4. Define models, views and templates for user management, dashboard, and data management
5. Implement user management functionalities allowing superuser to perform CRUD operations on users
6. Develop dashboard page to display relevant data based on the user's role
7. Implement permissions logic to control access and actions based on hierarchical levels:
   • Lowest tier users can add/view data assigned by seniors
   • Intermediate level users can update lower level data and add their own data

For assignment queries, contact:

Email: satyamm435@gmail.com

Phone: 9324865787