Question: 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

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 arme 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) Design a conceptual schema using EER diagram for storing data (members, groups) as explained. (b) Derive the database schema based on EER to Relational Mapping (c) Name member relation as MemberTable, and write a SQL script to create the member relation (Note: make sure to enforce referential integrity constraints). (d) Based on the database relations (tables) you derived from the EER diagram, write a SQL to retrieve member's first name, last name, email address, and study group name identified by group id 2 (we assume there are five study groups)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
