cs database design

i need help to solve the requirements from the paper for CS database design. Please see the attach