Draw an Entity Relationship Diagram for the following scenario:
PART A: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests. (15 points)
PART B: Please draw an Entity Relationship Diagram for the following scenario: A department store has a bridal registry. This registry keeps information about the customer (usually the bride), the products that the store carries, and the products for which each customer registers. Customers typically register for a large number of products, and many customers register for the same products. (15 points)
PART C: Examine the data models that you created for Part A and Part B. By way of a well written essay response, how would the respective models change (if at all) on the basis of these corresponding new assumptions?
Two patients have the same first and last names.
Researchers can be associated with more than one institution. (20 points)