• I'm really not going to do the work for you.

    I'll give you a hint to get you started though. There are three items listed above that are people. Figure out what they are. There's the first table I would define. Then, these people have to be related to each other in some way and the relationship can't simply be Parent to Child (in both the literal and figurative sense), so you'll need to define a table to support the relationships. Work that bit out. Now you've eliminated some of the requirements, start working through the rest in the same fashion.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning