ler Community Hospital Virtual Organization website and the Patton-Fuller Entities and Attributes document, develop an ERD with the following details?...
View the step-by-step solution to:

Question

How do I using information from the Patton-Fuller Community Hospital Virtual Organization website and the

Patton-Fuller Entities and Attributes document, develop an ERD with the following details?

  • Tables used
  • Defined use and relationships
  • Attributes
  • Fields in each table detail
  • Diagram of tables, entities, and relationships

Here is the document:

Patton-Fuller Community Hospital Electronic Patient Record Entities and Attributes

Patient Information

Name

Address

City

State

Zip

Phone

Date of birth

Gender

Parent/guardian name

Address

City

State

Zip

Phone

Primary physician name

Address

City

State

Zip

Registration ID

Insurer name

Address

City

State

Zip

Phone

Fax

Patient group ID

Patient subscriber ID

Attending physician

Medical diagnosis

Treatment plan

            Medication name

                        Dosage

                        Frequency

                        Duration

                        Start date

                        Comments

            Procedure

                        Date of procedure

                        Performed by

Results

            Blood pressure

            Questions

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes