Ahhh the joys of database design! I hope what they are really trying to teach is
that a good design will save you tonnes of time later on. If that's not the case,
then I'm not quite sure what the point is.
I've been working with databases since about 82 and there are some design
considerations with various platforms, but essential the thought process and logic
follows from one language to the next.
I've gotten pretty good at "doing the paper sketch" and having it work, but every so
often I still get complicated ones.
I have found that Access can get confused as well (at least the wizard part). One of
my designs was too complex for it, and it told me I needed another linkage.. I
didn't, but I took it as a sign that I should simplify the design as users would not
be able to generate quick and dirty reports..
I thought I knew access until I had to write VB code <yuck>, but I now have several
manuals and can even do help files <laugh>
Thomas F. Maher, Jr. wrote:
> I really wish the instructor of my database class had explained more of
> "This is how you
> construct a database when I give you one full page (!!) of English text and
> how to do it in under an hour and a half" BEFORE actually throwing this
> curve ball on the test.
>
> Right now I have:
>
> Student Advisee
> ----------- ---------------- Faculty
> StudentID (1)- - - - - - (8) StudentID ------------------
> [More] FacultyID (8) - - - - - - - - (1) FacultyID
> [More]
>
Depending on how complex some of the relationships get, you may want to have one
table for each group, and then a detail table that only contains the ID for each
group. The detail table becomes the "glue" for whichever query you need to make.
That is unless that is what you mean by the "Advisee" table (ie. Advisee is not a
separate person).
--
Making the Web Work for You (tm)
Susan Duncan ([EMAIL PROTECTED]) Voice: (613) 744-3283
Director, Internet Development Fax: (613) 744-1825
http://www.malico.com Toll Free: (877) WEB-PROS
http://www.OttawaWEB.COM
MALICO - Graphic Design and Internet Development
Founders: Ottawa-Hull Chapter-Int'l Webmasters Association
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
