Database Small Project Help required

Need some one experienced with Database, ER Diagram etc as there is a small project to be done in 24 hours from now. The details are available from link below [login to view URL] Only a particular part of that ER diagram will be considered to get the work done and that is Payment of room during a paticular time(Year, Semester,,Monthly, Weekly) Please apply after checking it Thanks