in reply to
Help me with Oracle course work
Sorry to be blunt...but you don't really expect us to do your homework for you, do you?
If you really have no idea where to start, I would humbly suggest you go to your instructor for guidance, or perhaps seek help from others in your class via something like a study group.
Otherwise, you can use Search and Super Search on this site to find examples of many of the features you describe, roll up you sleeves, and start writting some code....Then and only then, if you get stuck on a particular concept or point, you can show an example of what you are attempting and you will find many here who are willing to help.
But please, don't expect us to think for you.