Data Modeling and ER Diagrams for SaaS API Tables

Closed
Knorket.AI
Mississauga, Ontario, Canada
Founder
(34)
5
Project
Academic experience
60 hours per student
Student
Anywhere
Intermediate level

Project scope

Categories
Data analysis Data modelling Databases
Skills
data modeling entity relationship models application programming interface (api) er diagrams software as a service (saas)
Details

The main goal for the project is to convert the list of data tables of various SaaS based API's into proper data models using cube.dev or a similar approach. Additionally, the project aims to build ER models of the same to ensure efficient data organization and management.


This will involve several different steps for the learners, including:


- Analyzing the existing data tables and understanding the structure and relationships of the data.


- Utilizing cube.dev or similar tools to create data models that accurately represent the SaaS API data.


- Building ER models to visually represent the relationships between different entities in the data.


- Testing the data models and ER diagrams to ensure they accurately capture the original data and its relationships.


Deliverables


By the end of the project, learners should complete the following tasks:


- Developed proper data models using cube.dev or similar tools for the SaaS API data tables.


- Created ER models that visually represent the relationships between different entities in the data.


- Tested and validated the accuracy of the data models and ER diagrams.



Final deliverables:


- All source materials including the developed data models and ER diagrams.


- A written report explaining the process of converting the data tables into data models and building ER diagrams.


Mentorship

We will be available to provide assistance necessary as well as make available expert advisors where appropriate and needed. We will have onboarding followed by continued availability through discord for ongoing collaboration

About the company

Company
Mississauga, Ontario, Canada
2 - 10 employees
Business services, Technology

We incubate B2B SaaS startups and digital solutions for businesses and entrepreneurs (not to mention we run SaaS startups too!). We have a seasoned team with experience of shipping Full Stack Digital Products and engineering solutions and operating SaaS Products and PlatformsWe co-invest in startups and partner with ambitious businesses and entrepreneurs too!