Create database for the following scenario?

PLEASE help how to do this???

School of IT offers certificate courses in programming languages, databases and ms office application like MS word,Access, Powerpoint, Excel etc. a student can register for one or more than courses(maximum is 3) and at the end of the course he is offered a certificate for each of these courses after taking an exam for that course. student registers giving IC/Passport number, first name, last name,HP No, email add, date of birth and residential address. student after registration is assigned a unique student id. he/she can not sit for the class if he does not pay the fees within 7days of registration. each course has a fixed duration and a fee which must be paid at least 50%. remembering 50% can be paid before getting the certificate. on fees payment his/her student id,payment date, course id, and amount is entered and balance payment also (if any) is recorded. when the certificate is awarded, the system checks if payment for the course has been made fully if no , the entry is rejected by the database. in addition to the above the database should have the following. student attendance will be recorded entering the date, course id and student id.

a) List of student who have not paid fees

b) If a record is deleted from any table the user name and date should be logged in.

c) List of students who have paid the fees partial or full

some rules to observe:

- for student registration IC/Passport No, student id, first name, date of birth and address are compulsory.

- for fee payment the fee amount should be>0, student id and course id is compulsory. primary key should be transaction id.

-for certificate issue full fee must be paid.

- if the student has not paid at least 50% fees his attendance will be rejected by the system.

- for course information course id, course name, duration and fee are required whereas course description may be optional.