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 Queens College. Data requirements .Each member is uniquely identified by a member ID 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 o .Each group is identified by a unique group ID o Each group must have a unique name Note: you may need to have appropriate assumptions in requirements gathering process in order to make the specification complete (a) Design a conceptual schema using ER diagram for storing data (members, groups) as explained Specify key attributes of each entity type and structural constraints on each relationship type. a. (b) Derive the logical database schema based on ER to relational mapping rules. (c) Show any referential integrity constraints among derived logical table schemas
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
