Case study – Florida MIS Radiology

Case study – Florida MIS Radiology (continued – new information in italics) Florida MIS Radiology is a large imaging department located in Tampa, Florida providing…

Case
study – Florida MIS Radiology (continued – new information in
italics) Florida MIS Radiology is a large imaging department located
in Tampa, Florida providing diagnostic imaging services in two main
sites. The care team consists of 3 Radiologists, 4 nurses, 4
technologists, and 4 administrative specialists. Florida MIS
Radiology has the following imaging capabilities: • Computerized
Tomography scans • Nuclear medicine • Magnetic Resonance Imaging
• Ultrasound • X-Ray and Mammography • Radiography and
Fluoroscopy Florida MIS Radiology’s mission is “to advance the
knowledge and practice of diagnostic imaging by meeting the clinical
needs of the patients we serve”, and its vision is “to provide
high quality, patient centric diagnostic imaging services to patients
in the region and expand our sites to better serve our community”.
The department has the following goals: • Provide highest quality
advanced imaging services • Provide outstanding patient care and
service • Create strategic alliances on national and regional level
• Invest in IT for image delivery • Improve visibility of the
department Florida MIS Radiology’s leadership is considering
investing on information systems and it needs your assistance. While
Florida MIS Radiology’s leadership understands the benefits of
information systems, they are still hesitant to invest.

Your
thought is to demonstrate how a trivial scheduling system would
benefit the department. To that end, you decide to create a
proof-of-concept database to be operated by administrative staff,
nurses, and radiologists. Such database would significantly speed up
several business processes and solve issues related to paper based
medical records. This week we will address the following topic:
Patient database Learning objectives: • Create a simple database
After reviewing the Access tutorial provided in the Chapter Extension
6: Using Microsoft Access 2013 do the following: 1. Open Access 2016
(or 2013) and create a new database. If you do not have Microsoft
Access 2016 (or 2013): a. You may download a copy via USF’s Office
365 student subscription. More details at:
http://www.usf.edu/it/documentation/office365/personaldownload.aspx
Notice that you will not be able to install Access on a Mac. You will
not be able to install Access (or any of the Office 365 software) if
you already have Office 2013 installed in your computer (you will
need to uninstall any Office 2013 products first). b. Alternatively,
you can use it via the online USF portal at apps.usf.edu. After you
install the required Citrix client and login to the portal, head to
the Microsoft Office 2016 folder, and double click on Access 2016 to
open the software. Note that the software runs on the cloud and it
requires continuous access to the internet. Make sure to review the
instructions located in the main apps.usf.edu page on how to save
files on your local computer before start using any software from the
Apps portal. 2. Give the database the following name:
YourLastName_patientdatabase. For example:
Tsalatsanis_patientdatabase. 3. Create the following tables. Note
that the description in the parentheses refers to data types. Patient
PatientID (autonumber) Primary Key FirstName (Short text) MiddleName
(Short text) LastName (Short text) Address (Short text) Clinician
ClinicianID (autonumber) Primary Key ClinicianFirstName (Short text)
ClinicianMiddleName (Short text) ClinicianLastName (Short text)
PatientVisit PatientVisitID (autonumber) Primary Key PatientID
(Number) Foreign Key – required ClinicianID (Number) Foreign Key –
required VisitDate (date) Procedure (short text) Report (short text)
Appointment AppointmentID (autonumber) Primary Key PatientID (Number)
Foreign Key – required Procedure (short text) Date (date) 4. Create
the following relationships a. Between Patient and PatientVisit
(PatientID – one to many, enforce referential integrity) b. Between
Patient and Appointment (PatientID – one to many, enforce
referential integrity) c. Between Clinician and PatientVisit
(ClinicianID – one to many, enforce referential integrity) 5. Use
the table display to populate all tables with data of your choice.
Make sure that you have data for at least 5 patients, 2 clinicians,
10 patient visits, and 10 appointments. For Procedures you must use
the services provided by Florida MIS Radiology (e.g. CT scan, MRI,
etc). No need to report on organs/joints/structures at this time. For
Report you may use one of the following: Normal, Abnormal. 6. Extra
credit (10% if both items are completed successfully): Create 2 data
entry forms. One for appointments and one for patient visits. Primary
and Foreign Keys should not be visible on the forms. Patient and
Clinician Names must appear in the Visit form. Patient Name must
appear in the Appointment form. Labels used in the forms must be
legible: e.g. “Patient Name” instead of “PatientName” (notice
the space between the two words). 7. Save your file in your computer.
If you are using Access via USF Apps, make sure to save the file in a
local directory. 8. Prepare a report to explain how would this
database be used to schedule a visit, record patient data, and create
reports. Make sure to indicate who will be entering the data at each
stage. Discuss 3 benefits to the department due to the use of the
database. 9. Submit your report and the access database file.
Let’s block ads! (Why?)

Do you need any assistance with this question?
Send us your paper details now
We’ll find the best professional writer for you!

 



error: Content is protected !!