Re: standard and easy way to do schema design

From: <Summercoolness_at_gmail.com>
Date: Wed, 15 Aug 2007 08:39:20 -0700
Message-ID: <1187192360.616562.185340_at_q3g2000prf.googlegroups.com>


> You could start with atomic pieces of information and then look for
> relationships between them. For example, list Movies, Theaters, and
> ZipCodes on the board. Then it should be clear that there is a many-
> to-many relationship between Movies and Theaters, so you can add a
> relation for that. Then it should also be clear that there is a many-
> to-one relationship between ZipCodes and Theaters, so you can create a
> foreign key from Theaters to ZipCodes. It's not a substitute for real
> design work, but it might be enough for the 2-minute interview quiz.

will zipcode be just a property (a field) inside the theater table, or will zipcode need to be a table itself? Received on Wed Aug 15 2007 - 17:39:20 CEST

Original text of this message