Page 1 of 1

Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 2:01 am
by johnbasinger84
Hi all,


i am new to mysql. And m need to create a database design for logistics site with tarcking.
I need some ideas about the tables and design of database. Please any body help me.......
:cry:

I con't think about this
:banghead:

Re: Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 2:21 am
by Kieran Huggins
This is a complex topic, but one worth learning. Seriously.

http://dev.mysql.com/tech-resources/art ... ation.html

Re: Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 2:45 am
by johnbasinger84
Thank you very much.

And m not need normalization methods. i need is only the table contents sample database design for a logistics site with tracking system or sample site with tracking.

can u tell me about this?

Re: Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 2:48 am
by Kieran Huggins
normalization will help you understand how the data is connected and how to store it. It really is what you're looking for, just ignore the "performance" talk.

Re: Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 2:53 am
by johnbasinger84
Thank you.

:|

Re: Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 2:55 am
by johnbasinger84
can you tell me any web logistics or shipping web sites with tracking system.

please ya. This is my first sie.

sorry for disturbing you.

Re: Help needed on creating database design :roll:

Posted: Thu Jun 19, 2008 10:35 am
by Zoxive
A program I use that helps tremendously is MySql Workbench (Previous versions were DB Designer).

It helps me visualize, and see the tables so I can plan them out more efficiently.

Example Screenshot.