Re: standard and easy way to do schema design

<Summercoolness_at_gmail.com> wrote in message news:1187176120.886269.130090_at_z24g2000prh.googlegroups.com...
> I wonder instead of just brainstorming, there probably is
> a very standard and a simple way to do database schema design.
>
> let's say we are doing a website. the user can go over
> and type in the movie name and zipcode, and the website
> will return all the theaters showing that movie and at what
> time, for theaters in THAT zipcode only (for simplicity).
>
> so how do we just start and use a standard method that
> can be simple and very accurate to ensure good tables design?
>

If you want to get an overview of what data modeling and table design are all about, take a look at the outline in this website:

http://www.utexas.edu/its/windows/database/datamodeling/dm/overview.html

These techniques are overkill for the problem you outlined. But if the information needs grow, as they always do, you will soon be in the territory where you need these techniques or something like them. Received on Wed Aug 15 2007 - 14:21:42 CEST