The below figure illustrates the schema of three different data sources: MyGroup contains publications authored by members of a working group; MyConference contains publications of a conference series and associated workshops; MyPublisher contains articles that are published in journals. The arrows show the foreign key-to-primary key relationships. Give a consolidated global schema that covers all information of the source schemas.

MyGroup RELATION Publication RELATION AuthorOf RELATION GroupMember Pub ID: INT PRIMARY KEY VenueName: VARCHAR VenueType: VARCHAR Year. INT Title: VARCHAR Pub ID FK: INT PRIMARY KEY Member ID FK: INT PRIMARY KEY Member_ID: INT PRIMARY KEY I Name: VARCHAR Emal: VARCHAR MyConference RELATION ConfWorkshop RELATION Paper CW ID: INT PRIMARY KEY Year INT Location: VARCHAR Pap_ID: INT PRIMARY KEY Title: VARCHAR Authors: ARRAYI20] OF VARCHAR CW ID FK: INT 1( Organizer: VARCHAR AssociatedConf ID_FK: INT I MyPublisher RELATION Article RELATION Author RELATION Journal I Name: VARCHAR e: INT ournID: INT PRIMARY KEY Art D: INT PRIMARY KEYArt ID FK: INT PRIMARY KEY Title: VARCHAR Pers ID_FK: INT PRIMARY KEY Position: INT Volume: INT Joun_ID_FK: INT l Year RELATION Editor Journ ID FK: INT PRIMARY KEY Pers K FK: INT PRIMARY KEY RELATION Person Pers ID: INT PRIMARY KEY LastName: VARCHAR FirstName: VARCHAR Affiliation: VARCHAR