Secure Database Redesign and RESTful API Development for BoardSpace
Project scope
Categories
DatabasesSkills
mysql security testing restful api application programming interface (api) rest api development data integrity database schema database design scalability database analysisBoardSpace, a company specializing in web applications, seeks to enhance the security and efficiency of its existing mySQL database.
The current database structure needs a comprehensive redesign to improve performance, scalability, and security.
Additionally, a secure RESTful API must be developed to facilitate seamless interaction between the database and the web application. This project aims to provide learners with hands-on experience in database design, security best practices, and API development.
The goal is to create a robust, secure, and efficient system that can handle the company's data needs while ensuring data integrity and protection.
Key tasks include:
- Analyzing the current mySQL database structure.
- Designing a new, optimized database schema.
- Developing a RESTful API to interact with the redesigned database.
- Implementing security measures to protect data.
- Testing the new database and API for performance and security.
The project will result in a redesigned mySQL database and a secure RESTful API, both thoroughly tested and documented. The deliverables include:
- A detailed report on the current database analysis and the new database design.
- The redesigned mySQL database schema.
- A fully functional and secure RESTful API.
- Comprehensive testing documentation, including performance and security test results.
- User and developer documentation for the new database and API.
- Kickoff meeting with CEO and Developer
- Ongoing supervision and mentorship experienced Full Stack Developer
- Access to existing database schema
- Weekly meetings
- Added to the company Slack channel
About the company
BoardSpace is an online portal for the volunteer directors and administrators of condos, HOAs, non-profits and charities. BoardSpace overcomes the daunting task of looking after hundreds of documents, attending lots of meetings, preparing agendas, approving minutes and keeping on top of to-lists by providing boards with the tools to get their work done more efficiently and in less time.
Pat Crosscombe founded BoardSpace due to her experience on a condo board. BoardSpace is on a mission to organize the boards of directors of the world and was built by a team that understands the needs of condo and non-profit boards.
Portals
