[prog] database schema

[Jacinta Richardson]

Wolf Rising wrote:

> Machine Assigned
> userID               int   PK
> techID               int   PK
> issueDate            date
> returnDate           date

I have a question about your syntax here.  Are you saying that userID and techID 
are *independant* primary keys to this table or are you saying that userID && 
techID together form the primary key?  I'm pretty sure it's the second.

Usually it's easier to explain this by writing:

# Two-field primary key

Machine Assigned
 > userID               int
 > techID               int
 > issueDate            date
 > returnDate           date
primary key (userID, techID)

# Two independant primary keys

Machine Assigned
 > userID               int
 > techID               int
 > issueDate            date
 > returnDate           date
primary key (userID)
primary key (techID)


Likewise for your other tables, if you could clarify this for me I'll be happy 
to discuss 3rd normal form and these table with you.

All the best,

     Jacinta

-- 
    ("`-''-/").___..--''"`-._          |  Jacinta Richardson         |
     `6_ 6  )   `-.  (     ).`-.__.`)  |  Perl Training Australia    |
     (_Y_.)'  ._   )  `._ `. ``-..-'   |      +61 3 9354 6001        |
   _..`--'_..-_/  /--'_.' ,'           | contact at perltraining.com.au |
  (il),-''  (li),'  ((!.-'             |   www.perltraining.com.au   |