[Help] Good MySQL Structure?

jmarseng · July 13, 2012, 1:31pm

I was asked to create a database for my business but I have no idea where to get started, this was all that was given to me:

I am trying to find an outside salesman who will be paid a percentage of what he makes. I need you to see if you can design a database which:
[ol][li]Both the salesman and I can access[/li]
[li]Both the salesman and I can post data into[/li]
[li]If possible, has a function which can add and be used to calculate percentages.[/li][/ol]

The instructions seem vague and confusing, any idea how I should set this up?

ttbakiatwoam · July 13, 2012, 9:41pm

Well this should be fun…
How much HTML, PHP, CSS, and MySql do you know?

jmarseng · July 13, 2012, 10:42pm

I know a minor amount. I’m capable of creating a database through MySQL and I’m capable of linking it all together through PHP, as well as using loops, functions, etc.

ttbakiatwoam · July 13, 2012, 10:50pm

ok Then this will not be to hard,

First create your relational database, and the tables you will need at least two I think…
Second create a user login system.
Third create your view edit add pages
Fourth create your calculator functions… I would use some from of ajax so you dont have to leave the page to do the calculations.

jmarseng · July 13, 2012, 10:55pm

Thanks for the tip! It’s always hard to figure out a beginning structure to any site for another user, especially when THEY don’t even know what they want.

ttbakiatwoam · July 13, 2012, 10:59pm

Basically as you build your website and show the individual the result the details will fall into place, I have done several things like this recently so if you need help let me know or post it on the forums.