Hiearchy can be a good thing... but I don't believe the op can change the structure of the tables. 😉
CS... Please pardon me if I'm wrong, but this looks a whole lot like a homework problem. You'd probably get a better response if you posted what you've tried, so far.
--Jeff Moden
Change is inevitable... Change for the better is not.