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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!