Question
Develop an Entity Relationship Diagram (ERD) of an orthopedic clinic in San Diego. The database will be used to keep track of some aspects of
Develop an Entity Relationship Diagram (ERD) of an orthopedic clinic in San Diego. The database will be used to keep track of some aspects of healthcare business as described below.
The clinic is a small 7-physician clinic specializing in knee, elbow, hand, shoulder, hip, foot, ankle and other orthopedic problems. Physician information including physician ID, name, specialty (multivalue attribute), and address should be recorded.
When a patient arrives for their first visit, a record of this patient is created where a patient ID is assigned and personal information including name, gender, age, address is recorded. During the first visit the patient is assigned to a physician who then becomes her primary care physician. A physician may be assigned to many patients or may not be assigned to anyone.
A physician prescribes drugs to her patients. Each prescription records the drugs that are being prescribed by a physician to a patient. Each prescription also has a prescription ID and a date. A physician may or may not prescribe several prescriptions to a patient.
The clinic also maintains data on drugs. Each drug has a unique drug ID, description, expiry date, manufacturer, and price which are recorded. Any drug listed in the database may have a mild, moderate or severe interactions with a number of other drugs. Interaction type between two drugs must be captured. Use a unary relationship with interaction as an associative entity having type as a multivalue attribute.
Draw a ER diagram for the problem described above using the following guidelines. (6 points)
-All entities should be named as given in the problem
-Show all primary and foreign keys. Primary keys should be bold and underlined.
-Multivalue attributes should be shown as appropriate
-Choose appropriate names for the relationship and indicate all cardinality constraints for all relationships
-For those cases where the constraints are not explicitly indicated, make suitable assumptions and clearly write them in your solution.
-A many-many relationship with attributes should be shown as an associative entity.
-A ternary relationship should be shown as an associative entity.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started