HIM 6667: Patient Database Design for Florida MIS Radiology System

This assignment solution provides a detailed approach to creating a patient database for Florida MIS Radiology as part of the HIM 6667 Foundation in Management Information Systems course. The solution includes the creation of tables such as Patient, Clinician, PatientVisit, and Appointment in Microsoft Access, along with establishing relationships between these tables, enforcing referential integrity. Sample data is populated into each table, and extra credit is earned by creating data entry forms for appointments and patient visits, ensuring that primary and foreign keys are hidden, and patient and clinician names are displayed legibly. Finally, a report is prepared to explain how the database can be used to schedule visits, record patient data, and generate reports, highlighting the roles of administrative staff, nurses, and radiologists in data entry, and discussing three key benefits of the database to the department. Desklib provides this and many other solved assignments to help students.

HIM 6667 Foundation in Management Information Systems
Assignment 3
This file contains instructions and the topics of this week’s assignment.
DO NOT submit this file as your assignment. Use the template provided to
answer the assignment’s topics. Once you completed answering all topics, save
the template file and submit via Canvas. Locate the Assignment 3 link in the
Assignments folder and follow the instructions in the link below to upload your
file: https://community.canvaslms.com/docs/DOC-3119
Plagiarism - Turnitin
The assignment will be automatically reviewed for plagiarism using
turnitin. Turnitin results indicate the % of possible plagiarized material as well as
the controversial sections. Note that there is no specific “safe” % but
typically, scores greater than 15% may contain plagiarized information. I
strongly encourage reviewing the turnitin results before the assignment’s
deadline to correct any intentional or unintentional plagiarism incidents. To view
the turnitin results follow the instructions available at:
https://community.canvaslms.com/docs/DOC-3120
Typically, turnitin generates results within an hour. However, in periods of
high demand (e.g. when deadlines approach), it may take up to 24 hours for the
results to be generated. Please plan accordingly. If you resubmit your
assignment, turnitin results will be released 24 hours after re-submission.
Research Resources
Not all information is correct or equally important. It is advisable to use the
following ranking of evidence when performing your research:
1. Peer reviewed articles and Textbooks
2. Government portals (e.g. .gov websites)
3. News reports/Blogs/websites

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/personal-
download.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.