Hi all i am a newbie to oracle development. I have just created an EERD (Please see attached) and would like to know how to map my global schema into a set of normalised relations stating the origins of each relation and its role in the database schema. Also what other contraints could i have.