MappingAssertion (Head (Team(Y),partOfTeam(X,Y),Person(X)),
                                Map (ObjMap (X,emp(worksfor.ID_EMP )) ObjMap (Y,tm(worksfor.ID_TEAM )) ),
                                Body (SELECT worksfor.ID_EMP, worksfor.ID_TEAM 
                                           FROM worksfor
                                            WHERE worksfor.YEAR = 2007 ))

MappingAssertion (Head (Team(X),teamScore(X,Y)),
                                Map (ObjMap (X,tm(teams.ID_TEAM )) ValueMap (Y,xs:int,SUM( RACESRESULTS.POINTS )) ),
                                Body ( SELECT teams.ID_TEAM, SUM( racesresults.POINTS ) AS TEAMTOTALPOINTS 
                                            FROM racesresults, races, drivesFor, teams 
                                            WHERE racesresults.ID_RACE = races.ID_RACE AND 
                                                            racesresults.ID_DRIVER = drivesFor.ID_DRIVER AND 
                                                            drivesFor.ID_TEAM = teams.ID_TEAM AND 
                                                            YEAR( races.DATE ) =2007 AND 
                                                             drivesFor.YEAR =2007 
                                            GROUP BY teams.ID_TEAM ))

MappingAssertion (Head (Driver(X),name(X,Y),dateOfBirth(X,Z)),
                                Map (ObjMap (X,dr(drivers.ID_DRIVER )) 
                                          ValueMap (Y,xs:string,drivers.NAME) 
                                          ValueMap (Z,xs:date,drivers.BIRTH_DATE) ),
                                Body (SELECT drivers.ID_DRIVER, drivers.NAME, drivers.BIRTH_DATE
                                           FROM drivers))

MappingAssertion (Head (Team(X),name(X,Y)),
                                Map (ObjMap (X,dr(teams.ID_TEAM )) 
                                          ValueMap (Y,xs:string,teams.DESCRIPTION)  ),
                                Body (SELECT teams.ID_TEAM, teams.DESCRIPTION
                                           FROM teams))




