Create the following tables in the database of your choice. CD_INVENTORY CD_NAME: VARCHAR(60) Famous Blue Raincoat Blue Court and Spark Past Light Fundamental Blues on the Bayou Longing In Their Hearts Luck of the Draw Deuces Wild Nick of Time Both Sides Now PERF_ID: IN STOCK INT INT 12 102 101 101 105 104 103 104 104 103 104 101 24 17 9 229 19 18 25 17 11 13 PERFORMERS PERF ID: PERF NAME: INT VARCHAR(60) Joni Mitchell Jennifer Warnes B.B. King Bonnie Raitt William Ackerman 15 101 102 103 104 105 106 107 108 109 Bing Crosby Patsy Cline John Barry Leonard Cohen TYPE ID INT 10 12 11 10 16 17 18 12 PERF_TYPE TYPE_ID: TYPE NAME INT. CHAR(20) Popular Blues Folk Rock Classical New Age Classic Pop Country Soundtrack 10 11 12 13 14 15 16 17 18 Using SQL: 1. Create a left outer join using the CD_INVENTORY and PERFORMERS tables. 2. Create a right outer join using the CD_INVENTORY and PERFORMERS tables. 3. Create a full outer join using the CD_INVENTORY and PERFORMERS tables. Create the following tables in the database of your choice. CD_INVENTORY CD_NAME: VARCHAR(60) Famous Blue Raincoat Blue Court and Spark Past Light Fundamental Blues on the Bayou Longing In Their Hearts Luck of the Draw Deuces Wild Nick of Time Both Sides Now PERF_ID: IN STOCK INT INT 12 102 101 101 105 104 103 104 104 103 104 101 24 17 9 229 19 18 25 17 11 13 PERFORMERS PERF ID: PERF NAME: INT VARCHAR(60) Joni Mitchell Jennifer Warnes B.B. King Bonnie Raitt William Ackerman 15 101 102 103 104 105 106 107 108 109 Bing Crosby Patsy Cline John Barry Leonard Cohen TYPE ID INT 10 12 11 10 16 17 18 12 PERF_TYPE TYPE_ID: TYPE NAME INT. CHAR(20) Popular Blues Folk Rock Classical New Age Classic Pop Country Soundtrack 10 11 12 13 14 15 16 17 18 Using SQL: 1. Create a left outer join using the CD_INVENTORY and PERFORMERS tables. 2. Create a right outer join using the CD_INVENTORY and PERFORMERS tables. 3. Create a full outer join using the CD_INVENTORY and PERFORMERS tables.