Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment: Create an entry level EHR system for a clinic. This is a group assignment. Requirements: Software: Microsoft Access 2010 Tables: Minimum Required Tables: o

image text in transcribed
image text in transcribed
Assignment: Create an entry level EHR system for a clinic. This is a group assignment. Requirements: Software: Microsoft Access 2010 Tables: Minimum Required Tables: o Patient Table o Visit Table o Prescription Table Patient Education Table Make sure you create the appropriate relationships between these tables. Minimum Required Fields: Patient Table: Patient ID, First Name, Last Name, Social_Security_Number, Address, Birthdate, Insurance_Provider, Insurance_Policy_Number Visit Table: Visit ID, Patient ID, Visit_Date, Diagnosis_ ID, Visit Notes Prescription Table: Prescription_ID, Patient ID, Prescription_Date, Drug Name, Refills

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

Oracle Databases On The Web Learn To Create Web Pages That Interface With Database Engines

Authors: Robert Papaj, Donald Burleson

11th Edition

1576100995, 978-1576100998

More Books

Students also viewed these Databases questions