No one will do your work for you.
What have you learned so far? Show what you have tried, what is not working and you will find people are more willing to help. But the unpaid volunteers here won’t do your work for you.
Lookup the syntax for create table, constraints, procedures etc that will put you in the right direction then post back what you try and what doesn’t make sense.