View Single Post
  #4  
Old May 14th, 2010, 01:29 AM posted to microsoft.public.access.tablesdbdesign
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Testing DB and .....

Terry Cano wrote:
I see two weakness in my db design. BTW I'm self taught so there are two I'm
aware of and many I'm not.
I make a folder for my test db I can only run so many scenerios and move the
relationship around so many times...when do you know when to stop?
I start with a list of what I think I will ever need.
Level 1 Reports and QUERY that we will need on a daily or weekly bases
Level 2 Predict what we may need six months + down the road
Create the tables.....I then find that I'm looking at as many as six to ten
tables
that seems like a lot.
I can use a switchboard to keep the form count down...so should I be
thinking in that direction or ? ? ? ? ?

Archview Apartments
126 units over 250 people all with 2 vehicles....so it isn't that big of a
deal

My other project is creating something for the recording studio. Here I'm
dealing with clients and billing not many though. A ton of information on
songs, sounds used instruments used plug ins...when and what was edited back
up information, submission information, ISRC Codes....that could be six or so
tables.

Suggestions

Thanks

Terry


Sorry, that's a bit of a "How long is a piece of string?" question...

"Enough" tables is the right number to accurately describe all the "things"
and relationships between things about the subject you're trying to model.
Sometimes it's a pickup truck, sometimes it's a semi-trailer, sometimes it's
in between.

Before worrying about any of that, I would get out a pad of paper and
describe (at least to yourself) the situation you are attempting to model.
Once you have modeled the subject/situation and can figure out what tables
you need to access to answer questions from your data, then you can start
building. Building before you understand what the DB should do or how it
will be used is asking for trouble. Just my two cents.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201005/1