[Q.5] Answer the following 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 h 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 Member's email address is unique Each member can belong to any number of groups o o Each group is identified by a unique group ID o Each group must have a unique name (c) Design a conceptual schema using ER diagram for storing data (members, groups) as (d) Derive the logical database schema based on ER to relational mapping rules (e) Show any referential integrity constraints among derived table schemas. (f Name member table as MemberTable, and write a SQL script to create the member table Identify a super key, a candidate key, and the primary key make sure to enforce referential integrity constraints o o (e) Based on assumption that you have created and populated the database tables as a DBMS specific database tables, write a SQL script to retrieve member's ID, first name, last name, and group name in descending order of group name