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: oracle database connection windows pocket using net, change database server crystal report using vb6, attach database sql server 2005 using, write database description relations shown using, database management system project using ajax, organizing mysql database, import data database via odbc excel using vba, database organizing brochures, database operations wpf application using, update database csv file uploaded using php mysql, values database populate pdf file using aspnet, database creating raffle numbers using photoshop, tier database independant web development using aspnet, without database use login form using php, accessing sql database aspnet web form using, populate database csv, database data input, run multiple mysql database queries php send xml, free email database, adult web database, oracle database health check operations, mysql user system database, access database joomla, parse ebay store database, project database online quiz

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

Nº del proyecto: #12737813

Adjudicado a:


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)

16 freelancers están ofertando el promedio de $26 para este trabajo


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)
$25 USD en 1 día
(109 comentarios)

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)

Best regards. I think you want to do something like this [login to view URL], 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)

A proposal has not yet been provided

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

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)

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)

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)

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)

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)
$25 USD en 1 día
(0 comentarios)

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)
$20 USD en 0 días
(0 comentarios)
$14 USD en 5 días
(0 comentarios)

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)