Database security concern

Objective
   To complete a written assignment to help and an organization address its database security concerns.
      Required
   1. Use the template. Required for this assignment.
2. Threein-textcitationsrequired.
3. Three references are required to support the in-text
citations.
4. Do not change the template formatting. The
template is set for 12 points, Time New Roman.
   Instructions
  There are TWO case projects below. Your task is to select ONE of the case projects for this security assignment.
Your objective is the address the problem, provide security solutions and recommendations.
 1

   Project 1
Mark Smith Regional Hospital
   Aim: Mark Smith Regional Hospital is a multi-specialty hospital that includes several departments, rooms, doctors, nurses, compounders, and other staff working in the hospital. Patients having different kinds of ailments come to the hospital and get checkups done from the concerned doctors. If required, they are admitted to the hospital and discharged after treatment.
This case study aims to provide a written report for designing and developing a database for the hospital to maintain the records of various departments, rooms, and doctors in the hospital and address security concerns.
PLEASE NOTE THAT YOU ARE NOT DESIGNING A DATABASE. YOU WILL BE WRITING ABOUT SECURITY CONCERNS ABOUT THE DATABASE.
The database also maintains records of the regular patients, patients admitted in the hospital, the checkup of patients done by the doctors, the patients that have been operated on, and patients discharged from the hospital.
Description: In the hospital, there are many departments like Orthopedic, Pathology, Emergency, Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. There is an O.P.D. where patients come and get a card (that is, the entry card of the patient) for a checkup from the concerned doctor. After making an entry in the card, they go to the concerned doctor’s room, and the doctor checks up on their ailments. According to the conditions, the doctor either prescribes medicine or admits the patient to the concerned department. The patient may choose either a private or general room according to his/her need. But before getting admission to the hospital, the patient must fulfill certain formalities of the hospital like room charges, etc.