From: member33438@dbforums.com   
      
   Hi,   
      
      
      
   I would be very grateful if anyone could help me with the following. I   
   want to create a SIMPLE distributed database. It is as follows:   
      
      
      
   There is a institution which has branches all over the country offering   
   various courses.   
      
   I want to horizontally fragment the following table and place each   
   fragment in each branch.   
      
      
      
   COURSE (cno, branch, cname, lecturer)   
      
      
      
   I have 2 databases, one in Windows NT and the Other in HP-UX. How do I   
   created the GLOBAL schema? How do I create the LOCAL schema?   
      
      
      
   Also if I want to replicate the cno and name in each branch for   
   improvement of queries, how can I achive this?   
      
      
      
   Thanks & Regards,   
      
   Francis   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)