Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Genetic Databases

Authors: Martin J. Bishop

1st Edition

0121016250, 978-0121016258

More Books

Students also viewed these Databases questions