Question: You will need to develop an ER diagram from the following directions: Suppose you need to develop a data model to structure data about staff

You will need to develop an ER diagram from the following directions:
Suppose you need to develop a data model to structure data about staff and their activities in a dermatology clinic, and potentially other processes and activities in the clinic. There are different types of staff (e.g. medical assistants, doctors, nurse practitioners) who work with different types of patients and in different procedures (e.g. cancer treatment, surgery, diagnosis, education). We need to make sure to record how many hours they are working with distinct patients and in specific activities.
Task: Propose an ER diagram to keep track of this information.
Requirements: Your ER diagram should address entities and attributes listed in the description, but can also propose others that are not immediately apparent. You will need:
1. At least 4 entities, with least 4 attributes (on average) per entity.
2. At least 2 relationships, with minimum and maximum cardinality.
3. Any many-to-many relationship needs to be broken down.
4. PK and FK need to be identified.
5. Create a separate table that lists all the attributes, and identify the potential "data type" for each attribute. The data type should be one of the following:
character -- any text or number
integer -- any integer value
decimal -- any integer or decimal value
binary -- true or false / yes or no /1 or 0 only
date -- any day, month, year date

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 Programming Questions!