| From: Gill, Kathy <[EMAIL PROTECTED]>
| To: '[EMAIL PROTECTED]'
| Subject: WC:>: RE: >: My first database assignment: Part II
| Date: Wednesday, October 14, 1998 12:33 PM
<snip > .... while I chanted the mantra "One student can have many faculty
| > advisers.
| > One Faculty member can have many student advisees. Many students can
have
| > many faculty" I entered test data, and the database -seems- to work....
| >
| >
| YES -- at least this looks correct to me. In the prior example, you were
| creating an unnecessary variable, advisee ID -- the relationship is
| student-to-faculty, which this many-to-many schema shows. Me, I would
have
| made it one-to-many as I wouldn't have remembered double-majors!
Grrr! I found out that I had sketched out as the quick-and-dirty "10 minute
parameter brainstorming session" while I was hastily scratching out a
database model I scribbled down "Add possible functionality: Double Majors
for Students" and thought of the many-to-many relationship, which counts
for some, though I implimented it wrongly since I didn't have a danged
computer to test my model on! But I forgot to also bring over the
functionality to the "Students" field, and tinkering with that would
constitute a "change"... minus more percentage points...
Eh, it was optional. I've been getting very good as a tech writer in my
unnoffical position as a behind-the-scenes "Head of QA", at my present
contract position since I set up the policy & procedure for document any
issues to the computer systems... my knack for writing in tech writng
jargon has improved greatly. Maybe in the documentation I am preparing, I
can say that "The original design specifications had not called for this
functionality, but an initial groundwork has been constructed in order for
this functionality to be implimented in further iterations or code builds."
;}
*Sigh* I know that futzing up on that many-to-many will count not as one
error in programming, but three mistakes, since to fix the problem I had to
delete a field, add another field, and change a relationship. I know this
teacher. Like all the other teacher's in the CS department of Bridgewater
State College, even though they don't teach, don't give extra help, and
give out extremely un-"user friendly" manuals, they expect you to design
code exactly as they would, and dock you mucho points.
... that's why I lost faith in my Computer Science department, and left
college for three years for the real world in Boston.
-T.J. Maher
--------------------------------------------------------------------
Thomas F. Maher, Jr.| QA Engineer, Web Designer, Web Writer
[EMAIL PROTECTED] | "Computer Geek, Theatre Freak, Roleplaying
Weirdo"
Gadfly Design | http://www.geocities.com/TimesSquare/Alley/3039/
617-628-2533
____________________________________________________________________
--------------------------------------------------------------------
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.
---------------------------------------------------------------------
