Explore BrainMass
Share

Create an Entity-relationship Diagram

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Given the following business rules, create the Entity-relationship Diagram:

a. A health practrice has many doctors
b. Each doctor has many patients
c. Each patient has one of two insurance plans
d. Some patients may be seen by more than one doctor

Design the physical implementation

Setup the database using Microsoft Access

© BrainMass Inc. brainmass.com October 25, 2018, 7:08 am ad1c9bdddf
https://brainmass.com/computer-science/databases/492280
$2.19
See Also This Related BrainMass Solution

Create an ER Diagram

The scenario is that the Public Affairs Office at Highline University receives requests for speakers on particular topics. To be able to respond to such request, that office wants to build a database. In particular, it wants to keep track of topics, speakers, speeches, and organizations to which someone from Highline has spoken.

A. Make a list of possible entities for the Speaker database.

B. Create an IDEF1X E-R diagram showing only entities. Assume that there is an M:N relationship between SPEAKER and TOPIC.

C. For each relationship in your diagram, specify the relationship type, and the minimum and maximum cardinality on both parent and child. Name each relationship.

View Full Posting Details