From: member44272@dbforums.com   
      
   Hi there,   
      
   I'm studying DBs again after a summer break and have forgotten some   
   basics. I have 2 tables that I need to put into a DB but I'm not sure   
   how I should do it. Here are the table names with their columns:   
      
      
      
   Student Table:   
      
   Student_id First_name Last_name Sex Title   
      
      
      
   Attendance Table:   
      
   Student_id Att_date   
      
      
      
   The relationship is one-to-many, with Student being 'one'.   
      
      
      
   I'm not sure what the primary key and/or foreign keys will be in   
   the Attendance table as Student_id is obviously the primary key in   
   the Student table. Should there be a joint primary key in the   
   Attendance table?   
      
   Many thanks,   
      
   James   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)