Medical Lab Technician (LabTech): patient name, patient ID number, room number, procedure code, date, time, physician name, nurse name, lab results reference number, lab results, lab assessment date, allergies Medical Technician (MedTech): patient name, patient ID number, room number, procedure code, date, time, physician name, nurse name, allergies, food restrictions Patient (Patient): Patient address, phone number, date of admission, date of release, room charge, surgery/procedure charges by hospital, doctor name, doctor charges, itemized incidental charges, payment amount, payment date, payment type, payment account, HIPAA release information, living will information Patient Billing (PBill): Patient address, phone number, patient ID number, date of admission, date of release, room number, room charge, surgery/procedure charges by hospital, doctor charges, itemized incidental charges, payment amount, payment date, payment type, payment account Patient Admissions (PAdmit): Patient address, phone number, patient ID number, date of admission, doctor's name, room number, living will statement, patient billing information submitted, allergies, food restrictions The users and business rules represented in the hospital DBMS include the following (user accounts are in parentheses use the password for all accounts). Before you were hired, the hospital implemented a RBAC system. Note: The DBMS implementation has business rules and role-based access control (RBAC) issues that you must analyze, assess, and make requirements recommendations based on your security check of the DBMS. The DBMS represents a hospital system that contains fictitious patient data, representing the personally identifiable information (PII) and protected health information (PHI) of patients: billing data, payment data, illness diagnoses, prescribed medical procedures and medications, lab test results, and medical system user information, including the dates and times of delivery of patient services. In Part 1 – MySQL Databases, you will use a MySQL Database Management System (DBMS) installed on the Windows 10 (WINATK01) VM. You will experiment using the SQL-based MySQL DBMS and analyze packet captures within Wireshark to learn about securing access to a database. The lab should help you better understand the concepts of securing access to a DBMS. In this lab, you will develop parts of the RFP in preparation for your final Project 5 deliverable.
Section A: Background Information Review on SQL Lab Overview Include recommendation findings with final project request for proposal (RFP).Complete hands-on DBMS and Wireshark computing exercises.Analyze and assess a DBMS and make recommendations to secure a DBMS and network communications.Identify security issues and access control concerns to protect systems, data, and users.Use manuals and general guidance to generate an experimental results report.Use a free and open source MySQL Database Management System (DBMS) and Wireshark software applications.