diagram relation design

Job ID: 33651477

Budget: $2 – $8 USD

before start developing a system, we should try to draw out a diagram to understand the table relationship, how to draw a it, using what software on mac?

hybrid project

USER
0. username
1. email
2. role: admin/user
3. category: uiux/backend/wireframe/frontend
4. skill: laravel/figma/bootstrap
5. weekly hours available (integer)

PROJECT
1. project name
2. due date
3. Project Description
4. Budget (optional)

USER SUBMIT DAILY
1. choose project
2. click submit button
3. show date (auto or can edit)
4. Work hours for today
5. Summary of work (text area)

Assign USER to PROJECT
1. Choose project
2. add user (dropdown)
3. skill (dropdown)
4. category (auto assign after choose skill)

project prototype
https://www.figma.com/proto/SGxrdmcuY5IfuIZhYKGMKX/Project-Management?page-id=0%3A1&node-id=197%3A7501&viewport=241%2C48%2C0.39&scaling=min-zoom&starting-point-node-id=197%3A7501&show-proto-sidebar=1

please refer prototype and teach me how to do it, Thanks
Related categories: PHP Database Design