10.91 Answer the lollowing questions You are invited as a database architect to develop database schema for maintaining data for keeping track of the members of each Study Group organized for the CS students at Lehman College. .Each member is uniquely identified by a member ID o Each member in a study group must have an email address, first name, and last name o Member's email address is unique o Each member can belong to any number of groups .Each group is identified by a unique group ID o Each group must have a unique name (a) (b) (c) (d) Design a conceptual schema using ER diagram for storing data (members, groups) as explained. Derive the logical database schema based on ER to relational mapping rules. Show any referential integrity constraints among de Name member table as MemberTable, and write a SQL script to create the member table rived table schemas. Identify a super key, a candidate key, and the primary key make sure to enforce referential integrity constraints a. b. (e Based on the assumption that you have created and populated the database tables as a DBMS specific database tables, write a SOL script to retrieve member's ID, first name, last name, and group name in descending order of group name. IQ.51 Answer the following questions (a) (b) (c) create table named A with two columns x as int, y as varchar(5) create table named B with two columns v as int, w as varchar(5) Populate two tables by insert statement as shown below Table A Table B (d) Write a SQL statement to get union of two tables A and B (e) MySQL does not provide difference (or minus) and intersection set operations, write SQL statements to get intersection and difference of two tables Gi.e, A nB and A-B) using exists clause. () Given two relations (tables) shown below. Show results by . left outerJoin ofTI and T2 (on T?.P = T2.A) right outer join of TI and T2 (on Tl.Q T2.B) Table Tl 10 15 25 Table T2 10 10