Quote:
please draw a ERD table of this problem
This is your job, not ours !
anyway, the task is out of scope of this forum.
If your unable to complete the request, I recommend to hire a seasoned programmer for this job.
If it is part of your studying, have a talk with your teacher.