solve these please

Present your work in BOTH 'short text statement- it should look like this for short text statement PARTICIPATION (Points Earned, TeamID, DriverID, RaceID) RACE (RaceID, Race Title, Race Location, Race Date) RACE COMPONENT (RC ID, RC Type, RaceID) FINISH (Position, Result, Result, RC ID, DriverID) Graphical Representation: TEAM TeamID Team Name Team Manager DRIVER Driver ID Driver Age Driver Name TeamID PARTICIPATION Points Earned TeamID DriverID RaceID RACE RaceID Race Title Race Location Race Date RACE COMPONENT RC ID RC Type RaceID FINISH Position Result RC ID Driver ID RELATION (Field1, Field2, Field3...)AND "graphical representation" - RELATION_NAME ("PK-FK pairs"). 3. Ignore the last sentence regarding normalization ("3NF").[Remember: when do you have an incoming PK-FK referencing arrow, and when do you have an out-going one? Look at each relation (table) and ask: how many incoming arrows and how many out-going arrows this relation (table) has? Look at each relationship and ask: in this relationship, the arrow starts from which relation and ends at which other relation?] A.ER diagram describing a car racing league. Transform 1 the diagram into a relational schema that shows referential integrity constrains In addition, verify that the resulting relations are in 3NF. b.ER diagram describing a publisher specializing in large edited works. Transform the diagram into a relational scllema that shows referential integrity on- strains in addition, verify that the resulting relations are in 3NF. FIGURE 4- 36 EER diagram for a car racing league Belongs to TEAM Team ID Team Name Team Manager DRIVER Driver ID Driver Age Driver Name PARTICIPATION Points Earned FINISH FINISH Position RACE Race ID Race Tre Race Location Race Date RACE COMPONENT ACID RC Type Consis TEAM Belong to ROURE 4-05 car racing teague am Nero Team Manage DRIVER Dhe Diere Dhe Name PARTICIPATION Points Earned FINISH Position Result RACE Race ID Race Title Race Location Race Date HE Consists or RACE COMPONENT RC ID RC Type FIGURE 4-37 EER diagram for a publisher EDITOR EditorID Editor Name Editor FName Editor itution AUTHOR Author Auth Name Auth Last Name Auth First Name, Auth Middle Initial Auth Phone Auth Email (Auth Expertise Edes Editor Order Includes Has volumes BOOK Book Nr Book ISBN Book Title CHAPTER Chapter Chapter Number Chapter Title AUTHOR ASSIGNMENT Author Position Author Type la Lead Authors Contact Author Book Price ORDER LINE Orderline Nb OL Price OL Discount OL Ouantity ORDER Order ID Order Date Order Delivery Date WHOLESALE Custo Qust Name Places Screen Shot 2020-07-29 at 11.26.22 PM.png Present your work in BOTH 'short text statement- it should look like this for short text statement PARTICIPATION (Points Earned, TeamID, DriverID, RaceID) RACE (RaceID, Race Title, Race Location, Race Date) RACE COMPONENT (RC ID, RC Type, RaceID) FINISH (Position, Result, Result, RC ID, DriverID) Graphical Representation: TEAM TeamID Team Name Team Manager DRIVER Driver ID Driver Age Driver Name TeamID PARTICIPATION Points Earned TeamID DriverID RaceID RACE RaceID Race Title Race Location Race Date RACE COMPONENT RC ID RC Type RaceID FINISH Position Result RC ID Driver ID RELATION (Field1, Field2, Field3...)AND "graphical representation" - RELATION_NAME ("PK-FK pairs"). 3. Ignore the last sentence regarding normalization ("3NF").[Remember: when do you have an incoming PK-FK referencing arrow, and when do you have an out-going one? Look at each relation (table) and ask: how many incoming arrows and how many out-going arrows this relation (table) has? Look at each relationship and ask: in this relationship, the arrow starts from which relation and ends at which other relation?] A.ER diagram describing a car racing league. Transform 1 the diagram into a relational schema that shows referential integrity constrains In addition, verify that the resulting relations are in 3NF. b.ER diagram describing a publisher specializing in large edited works. Transform the diagram into a relational scllema that shows referential integrity on- strains in addition, verify that the resulting relations are in 3NF. FIGURE 4- 36 EER diagram for a car racing league Belongs to TEAM Team ID Team Name Team Manager DRIVER Driver ID Driver Age Driver Name PARTICIPATION Points Earned FINISH FINISH Position RACE Race ID Race Tre Race Location Race Date RACE COMPONENT ACID RC Type Consis TEAM Belong to ROURE 4-05 car racing teague am Nero Team Manage DRIVER Dhe Diere Dhe Name PARTICIPATION Points Earned FINISH Position Result RACE Race ID Race Title Race Location Race Date HE Consists or RACE COMPONENT RC ID RC Type FIGURE 4-37 EER diagram for a publisher EDITOR EditorID Editor Name Editor FName Editor itution AUTHOR Author Auth Name Auth Last Name Auth First Name, Auth Middle Initial Auth Phone Auth Email (Auth Expertise Edes Editor Order Includes Has volumes BOOK Book Nr Book ISBN Book Title CHAPTER Chapter Chapter Number Chapter Title AUTHOR ASSIGNMENT Author Position Author Type la Lead Authors Contact Author Book Price ORDER LINE Orderline Nb OL Price OL Discount OL Ouantity ORDER Order ID Order Date Order Delivery Date WHOLESALE Custo Qust Name Places Screen Shot 2020-07-29 at 11.26.22 PM.png