En curso

Organizing a Database

I need help creating a table structure for a database I'm creating. I don't need it built; simply I need to know which tables I need and how to link them most efficiently.

The purpose of the database is to create custom workouts for users of my website.

The user specifies the equipment they have access to (dumbbells, barbells, etc.), then the system creates a workout using only exercises that can be done with the equipment the user has selected.

So here are the tables I know I need:

user data that shows the equipment options they have

exercise data that shows what equipment is required for the exercise along with other information like category and a link to a video

workout data that creates the workouts for each user

Where I'm stuck is connecting the dots. Do I need additional tables to relate the three or is there a way to do it with just those?

I'm sure there is a very simple solution, I'm just not familiar enough with relational databases to figure it out.

Habilidades: Administración de bases de datos, Desarrollo de base de datos, Programación de bases de datos, MySQL, SQL

Ver más: organizing mysql database, database organizing brochures, populate database csv, database data input, free email database, mysql user system database, access database joomla, project database online quiz, wikipbx freeswitch database

Información del empleador:
( 1 comentario ) Roseville, United States

ID de proyecto: #12737813

Adjudicado a:

carlamorillo2

Hi there, You certainly need some intermediate tables to tie the existen tables as needed. For instace, a table for user + selected equipement. I'm a database designer/developer and admin and work with MySQL, PostgreSQ Más

$15 USD en 0 días
(0 comentarios)
0.0

16 los freelancers están ofertando un promedio de $26 para este trabajo.

truongnguyen86

Hello there, i'm expert on design the database also implementation on many DBMS, from Oracle, SQL Server, MySQL....etc. Base on your requirement i can expect what tables you need but i still need to discuss more with y Más

$50 USD en 1 día
(138 comentarios)
6.4
$25 USD en 1 día
(109 comentarios)
5.8
SolomonM

How's it going? I'm a web developer & designer from Los Angeles, CA. You can check my profile for my reviews and past work. Can you give me some more details about what you need? Thanks

$35 USD en 3 días
(4 comentarios)
4.5
kelgar765

Best regards. I think you want to do something like this https://virtuagym.com/, here you find all the tutinas you could need, I think that you can create your same web sub of this. I just help you, what you need Más

$30 USD en 1 día
(4 comentarios)
3.7
jagdishbhatt38

A proposal has not yet been provided

$50 USD en 2 días
(8 comentarios)
3.9
$30 USD en 1 día
(8 comentarios)
3.1
vw7590795vw

Please review my profile. I have 7.1 years experience in SQL. Please let me know more details and when we will start. Sky pe: jikenjd

$13 USD en 0 días
(10 comentarios)
3.2
josemontenegro13

Computer Engineer. Plenty of experience solving algorithmic problems via code, also including database problems like this one

$25 USD en 1 día
(2 comentarios)
1.7
floodmons

I have a solution for your project. You don't need to create new table. I have experiences in database design. If you hire me, I will complete perfectly within 1~2 hours.

$25 USD en 1 día
(1 comentario)
0.9
donfoss6

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, S Más

$25 USD en 1 día
(4 comentarios)
3.3
Hassan1859

Hey, We are running a well-reputed software house which consists of professional UI designers and developers. We have extensive experience in Graphics designing ,building incredible PHP based websites, Wordpress Web Más

$25 USD en 1 día
(0 comentarios)
0.0
$25 USD en 1 día
(0 comentarios)
0.0
ksinghrajeev

I have work extensively in DB side. I can provide your the right table details for you. Ping to to discuss. Thanks, Rajeev

$20 USD en 1 día
(0 comentarios)
0.0
$20 USD en 0 días
(0 comentarios)
0.0
$14 USD en 5 días
(0 comentarios)
0.0
sahilnarain

Hi! I have experience in designing big corporate data warehouses (I've worked with IBM and JLL for this) and I could give you some insights into the considerations that need to be kept in mind while designing somethin Más

$15 USD en 1 día
(0 comentarios)
0.0