schema from part 1, needs to be updated and tested on Oracle