Organizing a Database

$10-30 USD

Completed

Posted

over 7 years ago

$10-30 USD

Paid on delivery

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.

Database Administration

Project ID: 12737813

About the project

14 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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, PostgreSQL, SQLServer and Oracle. I would like to help you with this project. Please consider my bid and let me know if you have any question. Regards. Carla.

$15 USD in 0 day

5.0

(12 reviews)

3.8

14 freelancers are bidding on average $25 USD for this job

@jagdishbhatt38

A proposal has not yet been provided

$50 USD in 2 days

4.9

(29 reviews)

4.9

@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 in 3 days

5.0

(4 reviews)

4.5

@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 in 0 day

5.0

(24 reviews)

4.2

@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 something like this. Please get in touch with me if you would like to discuss it with me!

$15 USD in 1 day

5.0

(8 reviews)

3.5

@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 in 1 day

5.0

(2 reviews)

2.4

@josemontenegro13

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

$25 USD in 1 day

4.5

(2 reviews)

2.1

@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 in 1 day

5.0

(2 reviews)

0.9

@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 Websites web apps with a team of professional developers. We can assure you that we have all the skills and expertise that you require. We believe in 100% satisfaction to the customers by accomplishing their requirements. Regards, Hassan and team.

$25 USD in 1 day