Database with sql and Er diagram

I have a database assignment that needs to be done in sql i need it within 24hours it needs to be done perfect you need to draw ER diagram aswell. the book used for this assignment is database system a pratical approach to desgin implementation and management 4th edition by thomas connolly carolyn begg it is easily available on internet. i have attached my 1st assignment you might need it and you can also check what kind of work i want. ER diagram needs to be changed from 1st assignment. I have a deadline so please accept the assginment only if you can meet the deadline. and also you to meet all the requirement mentioned in the document please read it carefully. thanks.