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,