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 eg medical assistants, doctors, nurse practitioners who work with different types of patients and in different procedures eg 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:
At least entities, with least attributes on average per entity.
At least relationships, with minimum and maximum cardinality.
Any manytomany relationship needs to be broken down.
PK and FK need to be identified.
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 or 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
