I see you are in a hurry with your homework! Well, I'm in a hurry for a couple cents dollar, so we may collaborate :D
I have advanced knowledge of SQL / relational databases. I had many subjects about them during my Degree in Computer Science. I also make use of them at my work in a daily manner. I've took a look at the requeriments, plus the PDF provided, and assured I understood it and that I could do it before bidding. If you really need it for the 7th of june that would be possible, thus I'm bidding high for the hurry. I would need you to clarify me a couple of details: for instance, if you need the statements in some specific "flavour" of SQL, if it needs to be ANSI SQL, or if MySQL, for instance, could be accepted. If you don't provide info about this, I would accomplish my work as standard as it can be. And I only see ONE file, not two. Finally, to my understanding, there are no E-R diagrams to be done; there is just one PROVIDED in order to do what they are asking for based on it.
Finally, there's a note saying "ITECH5006 Students Only". I need to know if this is the case, just to know if that's to be done or not.
If the database must by DUMPED to a real RDBMS, you must supply access as soon as possible. If not, I would send you 3 files you should send by yourself to the online teaching platform.
I would need you to help me provide some example data, mainly some local addresses and so.
Hope to hear from you soon. You won't have problems working with me ;)