Help needed on creating database design :roll:

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
johnbasinger84
Forum Newbie
Posts: 4
Joined: Thu Jun 19, 2008 1:32 am
Location: Chennai

Help needed on creating database design :roll:

Post 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:
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Re: Help needed on creating database design :roll:

Post by Kieran Huggins »

This is a complex topic, but one worth learning. Seriously.

http://dev.mysql.com/tech-resources/art ... ation.html
johnbasinger84
Forum Newbie
Posts: 4
Joined: Thu Jun 19, 2008 1:32 am
Location: Chennai

Re: Help needed on creating database design :roll:

Post 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?
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Re: Help needed on creating database design :roll:

Post 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.
johnbasinger84
Forum Newbie
Posts: 4
Joined: Thu Jun 19, 2008 1:32 am
Location: Chennai

Re: Help needed on creating database design :roll:

Post by johnbasinger84 »

Thank you.

:|
johnbasinger84
Forum Newbie
Posts: 4
Joined: Thu Jun 19, 2008 1:32 am
Location: Chennai

Re: Help needed on creating database design :roll:

Post 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.
User avatar
Zoxive
Forum Regular
Posts: 974
Joined: Fri Apr 01, 2005 4:37 pm
Location: Bay City, Michigan

Re: Help needed on creating database design :roll:

Post 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.
Post Reply