Re: standard and easy way to do schema design
Date: Wed, 15 Aug 2007 04:30:49 -0700
On Aug 15, 1:08 pm, Summercooln..._at_gmail.com wrote:
> 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?
The standard method is to make a functional design based upon the endusers
The determine your entities and the relations between entities, then you convert your entities to tables, and your functions to screens. This is basically what products like Designer and JDeveloper do. Entity Relationship Modeling is a department of Information Science. What you describe is taking a pencil, sticking your thumb in the air, and starting 'somewhere'. This is called Woodshed Modeling. Regrettably this is how most applications are build nowadays. This won't work, ever.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Aug 15 2007 - 13:30:49 CEST