HIM 6667: Patient Database Design for Florida MIS Radiology System
VerifiedAdded on 2023/06/07
|5
|1275
|247
Homework Assignment
AI Summary
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.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
1 out of 5